Quiz › Formulas & Functions › XLOOKUP, INDEX, MATCH

XLOOKUP, INDEX, MATCH: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

A1:A3 has Apple, Mango, Kiwi. B1:B3 has 50, 80, 30. What will this formula return?
=XLOOKUP("Kiwi",A1:A3,B1:B3)
- A. 30
- B. 80
- C. Kiwi
- D. 50
Show the answer
A — 30. XLOOKUP finds Kiwi in A and returns the same row of B: 30.
A1:A3 has Apple, Mango, Kiwi. What will this formula return?
=MATCH("Mango",A1:A3,0)
- A. 2
- B. 1
- C. Mango
- D. 80
Show the answer
A — 2. MATCH gives the position. Mango is the 2nd item.
B1:B3 has 50, 80, 30. What will this formula return?
=INDEX(B1:B3,3)
- A. 30
- B. 80
- C. 3
- D. 50
Show the answer
A — 30. INDEX returns the 3rd item in the range: 30.
A1:A3 has Apple, Mango, Kiwi. B1:B3 has 50, 80, 30. What will this formula return?
=XLOOKUP("Grape",A1:A3,B1:B3,"Not found")
- A. #N/A
- B. Not found
- C. Grape
- D. 0
Show the answer
B — Not found. Grape is not there, so XLOOKUP shows your own text.
A1:A3 has Apple, Mango, Kiwi. B1:B3 has 50, 80, 30. What will this formula return?
=INDEX(B1:B3,MATCH("Apple",A1:A3,0))
- A. 80
- B. 50
- C. 1
- D. Apple
Show the answer
B — 50. MATCH finds Apple at position 1. INDEX returns item 1 of B: 50.