Lookup & Reference =LOOKUP(lookup_value, lookup_vector, [result_vector])

Quiz =LOOKUP — 10 Questions

10 quiz questions about =LOOKUP — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← LOOKUP ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What usually causes #N/A in =LOOKUP?

Question 2 of 10 2/10

Is =LOOKUP volatile?

Question 3 of 10 3/10

Which statement about =LOOKUP is correct?

Question 4 of 10 4/10

Does =LOOKUP return a dynamic array?

Question 5 of 10 5/10

In =LOOKUP, which is argument #1?

Question 6 of 10 6/10

Which function is NOT related to =LOOKUP?

Question 7 of 10 7/10

In =LOOKUP, which is argument #3?

Question 8 of 10 8/10

What is the type of argument “result_vector” in =LOOKUP?

Question 9 of 10 9/10

What is the output type of =LOOKUP?

Question 10 of 10 10/10

How many arguments does =LOOKUP have in total?

Click a question to see the answer.

1. What usually causes #N/A in =LOOKUP?

A. If lookup_value is smaller than the smallest value in lookup_vector, LOOKUP returns the #N/A error value. ✓
B. Requires add-in
C. Output is always a dynamic array
D. Only works in old versions

Explanation: If lookup_value is smaller than the smallest value in lookup_vector, LOOKUP returns the #N/A error value. — Fix: Check the lookup value and the first value in the range

2. Is =LOOKUP volatile?

A. No
B. —
C. No ✓
D. Yes

Explanation: LOOKUP is not volatile.

3. Which statement about =LOOKUP is correct?

A. Select entire column for best performance
B. Requires add-in
C. Output is always a dynamic array
D. Consider one of the newer lookup functions, depending on which version you are using. Use VLOOKUP to search one row or column, or to search multiple rows and columns (like a table). It's a much improved version of LOOKUP. Watch this video about how to use VLOOKUP. If you are using Microsoft 365, use XLOOKUP - it's not only faster, it also lets you search in any direction (up, down, left, right). ✓

Explanation: Correct: Consider one of the newer lookup functions, depending on which version you are using. Use VLOOKUP to search one row or column, or to search multiple rows and columns (like a table). It's a much improved version of LOOKUP. Watch this video about how to use VLOOKUP. If you are using Microsoft 365, use XLOOKUP - it's not only faster, it also lets you search in any direction (up, down, left, right).

4. Does =LOOKUP return a dynamic array?

A. No ✓
B. —
C. Yes
D. No

Explanation: LOOKUP does not spill.

5. In =LOOKUP, which is argument #1?

A. lookup_vector
B. lookup_value ✓
C. criteria
D. array

Explanation: Argument #1 is “lookup_value”.

6. Which function is NOT related to =LOOKUP?

A. HLOOKUP
B. POISSON.DIST ✓
C. VLOOKUP
D. XLOOKUP

Explanation: “POISSON.DIST” is not related to LOOKUP.

7. In =LOOKUP, which is argument #3?

A. lookup_vector
B. value
C. result_vector ✓
D. array

Explanation: Argument #3 is “result_vector”.

8. What is the type of argument “result_vector” in =LOOKUP?

A. Range ✓
B. Array
C. Reference
D. Date

Explanation: Type of “result_vector” is “Range”.

9. What is the output type of =LOOKUP?

A. Number
B. Mixed ✓
C. Date
D. Reference

Explanation: Output is “Mixed”.

10. How many arguments does =LOOKUP have in total?

A. 3
B. 4 ✓
C. 6
D. 5

Explanation: =LOOKUP has 3 required, 1 optional (4 total).