VLOOKUP: Excel Quiz

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

A1:B3 has Apple 50, Mango 80, Kiwi 30. What will this formula return?
=VLOOKUP("Mango",A1:B3,2,FALSE)
- A. 30
- B. 80
- C. 50
- D. Mango
Show the answer
B — 80. VLOOKUP finds Mango and returns column 2 of that row: 80.
A1:B3 has Apple 50, Mango 80, Kiwi 30. What will this formula return?
=VLOOKUP("Kiwi",A1:B3,1,FALSE)
- A. 80
- B. #N/A
- C. 30
- D. Kiwi
Show the answer
D — Kiwi. Column 1 is the name column, so you get Kiwi back.
A1:B3 has Apple 50, Mango 80, Kiwi 30. What will this formula return?
=VLOOKUP("Grape",A1:B3,2,FALSE)
- A. #N/A
- B. 30
- C. 0
- D. Grape
Show the answer
A — #N/A. Grape is not in the list, so VLOOKUP shows #N/A.
A1:B3 has Apple 50, Mango 80, Kiwi 30. What will this formula return?
=VLOOKUP("Apple",A1:B3,3,FALSE)
- A. #REF!
- B. 0
- C. #N/A
- D. 50
Show the answer
A — #REF!. The table has only 2 columns. Asking for column 3 gives #REF!.
A1:B3 has Apple 50, Mango 80, Kiwi 30. What will this formula return?
=VLOOKUP("mango",A1:B3,2,FALSE)
- A. 80
- B. #N/A
- C. mango
- D. 0
Show the answer
A — 80. VLOOKUP does not mind small or capital letters. It finds Mango: 80.