Practice by topic / Excel / Lookups
Lookups pull a value from one table into another — a price, a name, a rate. They come up in almost every Excel job interview test. These 10 exercises build up step by step, starting with look up a quarterly value, look up a score by category header, look up a month's budget.
3 of 10 free · no sign-up needed · graded on the formula you write
A1:C2 has quarter labels (Q1, Q2, Q3) in row 1 and revenue in row 2. Write a formula in D2 that returns the revenue for Q2 using HLOOKUP.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Q1 | Q2 | Q3 | |
| 2 | 1000 | 1500 | 1200 | ? |
Use =HLOOKUP("Q2",A1:C2,2,FALSE).
Right — HLOOKUP searches across the first row for the match and returns a value from the specified row below it.
Expected result in D2: 1500
A1:C2 has category names (Math, Science, Art) in row 1 and scores in row 2. Write a formula in D2 that returns the Science score using HLOOKUP.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Math | Science | Art | |
| 2 | 85 | 92 | 78 | ? |
Use =HLOOKUP("Science",A1:C2,2,FALSE).
Good — HLOOKUP is the row-oriented counterpart to VLOOKUP, searching horizontally instead of vertically.
Expected result in D2: 92
A1:C2 has month names in row 1, budget amounts in row 2. Write a formula in D2 that returns the budget for 'Feb' using HLOOKUP.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Jan | Feb | Mar | |
| 2 | 500 | 600 | 550 | ? |
Use =HLOOKUP("Feb",A1:C2,2,FALSE).
Right — HLOOKUP finds 'Feb' in row 1 and pulls the value from row 2 of that same column.
Expected result in D2: 600
A1:C2 has team names in row 1, points in row 2. Write a formula in D2 that returns the points for 'Falcons' using HLOOKUP.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Hawks | Falcons | Eagles | |
| 2 | 45 | 52 | 38 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:C2 has semester labels in row 1, enrollment counts in row 2. Write a formula in D2 that returns enrollment for 'Fall' using HLOOKUP.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Spring | Fall | Summer | |
| 2 | 200 | 350 | 90 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:C2 has region names in row 1, headcounts in row 2. Write a formula in D2 that returns headcount for 'East' using HLOOKUP.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | West | East | North | |
| 2 | 30 | 45 | 20 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:C2 has product line names in row 1, margin percentages in row 2. Write a formula in D2 that returns the margin for 'Premium' using HLOOKUP.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Basic | Premium | Deluxe | |
| 2 | 0.2 | 0.35 | 0.4 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:C2 has shift names in row 1, staffing counts in row 2. Write a formula in D2 that returns staffing for 'Night' using HLOOKUP.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Morning | Night | Evening | |
| 2 | 8 | 4 | 6 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:C2 has model years in row 1, prices in row 2. Write a formula in D2 that returns the price for '2023' using HLOOKUP.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 2022 | 2023 | 2024 | |
| 2 | 20000 | 22000 | 24000 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1:C2 has version labels in row 1, note counts in row 2. Write a formula in D2 that returns note count for 'v2' using HLOOKUP.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | v1 | v2 | v3 | |
| 2 | 5 | 12 | 8 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →