What would the result of the following formula be: =XLOOKUP(A5,B1:B3,A1:A3)

What would the result of the following formula be: =XLOOKUP(A5,B1:B3,A1:A3)

(A) Ben

(B) James

(C) Anne

(D) 32

Explanation

The result of the following formula: =XLOOKUP(A5,B1:B3,A1:A3) is James.

The XLOOKUP needs to find “Small” in column B (row 1-3) and when it does, it needs to return the value in the same row from column A (1-3).

Conclusion

This question is from the Quiz section of the first lesson “Working with Data in Excel” from the HubSpot Excel for Marketers course. You can find answers to all the quiz questions asked in this course on our HubSpot Excel for Marketers Lesson Quiz Answers page.

Leave a Comment

Share via
Copy link
Powered by Social Snap