Excel – Lookup Functions
Practice Excel lookup function interview questions covering VLOOKUP, INDEX/MATCH, XLOOKUP, and common lookup patterns. Answer questions and receive feedback on correctness and approach. Ideal for data analyst and finance interview prep. First 2 questions are free with full feedback.
- Level Intermediate
- Questions 12
Try any track free — first 2 questions include full AI feedback. Subscribe to finish the track and unlock everything. Type or speak your answer — the first 2 questions include scoring and detailed AI feedback.
Sample excel – lookup functions interview questions
Preview 6 questions from this track in quiz order. In the full quiz you answer one at a time — type or speak — then get a score and feedback.
-
What is the difference between VLOOKUP and INDEX/MATCH?
What a strong answer includes
INDEX/MATCH is more flexible and can look left.
-
Write a VLOOKUP that finds a price by product ID.
What a strong answer includes
Correct range and exact match (FALSE).
-
How do you do a left lookup in Excel?
What a strong answer includes
Uses INDEX/MATCH.
-
What does the range_lookup argument in VLOOKUP do?
What a strong answer includes
TRUE for approximate; FALSE for exact.
-
Explain XLOOKUP and its advantages.
What a strong answer includes
Simpler syntax and can look in any direction.
-
How do you handle errors in a lookup formula?
What a strong answer includes
Uses IFERROR or IFNA.