1
Flag Whether a Looked-Up Price Is Expensive
Free
A2:B4 maps Product to Price. D2 holds a product name. Write a formula in E2 that looks up the price and returns 'Expensive' if it's over 10, otherwise 'Affordable'.
| A | B | C | D | E |
|---|
| 1 | | | | | |
|---|
| 2 | Widget | 9.99 | | Gadget | ? |
|---|
| 3 | Gadget | 14.5 | | | |
|---|
| 4 | Gizmo | 7.25 | | | |
|---|
Show the solution
Nest VLOOKUP inside IF's condition: =IF(VLOOKUP(D2,A2:B4,2,FALSE)>10,"Expensive","Affordable")
Right — wrapping VLOOKUP inside IF lets you classify the looked-up value directly.
Expected result in E2: Expensive
2
Check Stock Level After a Lookup
Free
A2:B4 maps Product to Stock Count. D2 holds a product name. Write a formula in E2 that looks up the stock count and returns 'Reorder' if under 10, otherwise 'OK'.
| A | B | C | D | E |
|---|
| 1 | | | | | |
|---|
| 2 | Widget | 5 | | Gizmo | ? |
|---|
| 3 | Gadget | 40 | | | |
|---|
| 4 | Gizmo | 8 | | | |
|---|
Show the solution
Use =IF(VLOOKUP(D2,A2:B4,2,FALSE)<10,"Reorder","OK")
Good — this pattern combines a lookup with a business-rule threshold in one formula.
Expected result in E2: Reorder
3
Determine Pass/Fail From a Looked-Up Score
Free
A2:B4 maps Student to Score. D2 holds a student name. Write a formula in E2 that looks up their score and returns 'Pass' if 60+, otherwise 'Fail'.
| A | B | C | D | E |
|---|
| 1 | | | | | |
|---|
| 2 | Alex | 55 | | Alex | ? |
|---|
| 3 | Sam | 82 | | | |
|---|
| 4 | Priya | 91 | | | |
|---|
Show the solution
Use =IF(VLOOKUP(D2,A2:B4,2,FALSE)>=60,"Pass","Fail")
Right — this combines a name-based lookup with a pass/fail threshold check.
Expected result in E2: Fail
4
Determine Free Shipping Eligibility From a Looked-Up Order Total
A2:B4 maps Order ID to Total. D2 holds an order ID. Write a formula in E2 that looks up the total and returns 'Free Shipping' if 75+, otherwise 'Paid Shipping'.
| A | B | C | D | E |
|---|
| 1 | | | | | |
|---|
| 2 | ORD1 | 90 | | ORD3 | ? |
|---|
| 3 | ORD2 | 40 | | | |
|---|
| 4 | ORD3 | 75 | | | |
|---|
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 →
5
Flag a Looked-Up Rating as Featured
A2:B4 maps Product to Rating. D2 holds a product name. Write a formula in E2 that looks up the rating and returns 'Featured' if 4.5 or higher, otherwise 'Standard'.
| A | B | C | D | E |
|---|
| 1 | | | | | |
|---|
| 2 | Widget | 4.8 | | Gizmo | ? |
|---|
| 3 | Gadget | 3.9 | | | |
|---|
| 4 | Gizmo | 4.5 | | | |
|---|
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 →
6
Determine Discount Eligibility From a Looked-Up Tenure
A2:B4 maps Customer to Years as Member. D2 holds a customer name. Write a formula in E2 that looks up tenure and returns 'Loyalty Discount' if 3+ years, otherwise 'No Discount'.
| A | B | C | D | E |
|---|
| 1 | | | | | |
|---|
| 2 | Chen | 5 | | Lena | ? |
|---|
| 3 | Diego | 1 | | | |
|---|
| 4 | Lena | 3 | | | |
|---|
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 →
7
Classify a Looked-Up Response Time as Within SLA
A2:B4 maps Ticket to Response Hours. D2 holds a ticket ID. Write a formula in E2 that looks up the response time and returns 'Within SLA' if 4 or under, otherwise 'SLA Breach'.
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 →
8
Determine a Grade Band From a Looked-Up Score
A2:B4 maps Student to Score. D2 holds a student name. Write a formula in E2 that looks up the score and returns 'Honors' if 90+, otherwise 'Standard'.
| A | B | C | D | E |
|---|
| 1 | | | | | |
|---|
| 2 | Alex | 95 | | Alex | ? |
|---|
| 3 | Sam | 82 | | | |
|---|
| 4 | Priya | 91 | | | |
|---|
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 →
9
Flag a Looked-Up Balance as Overdrawn
A2:B4 maps Account to Balance. D2 holds an account name. Write a formula in E2 that looks up the balance and returns 'Overdrawn' if negative, otherwise 'OK'.
| A | B | C | D | E |
|---|
| 1 | | | | | |
|---|
| 2 | Acc1 | -50 | | Acc1 | ? |
|---|
| 3 | Acc2 | 200 | | | |
|---|
| 4 | Acc3 | 0 | | | |
|---|
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 →
10
Determine Bulk Pricing Eligibility From a Looked-Up Quantity
A2:B4 maps Order to Quantity. D2 holds an order ID. Write a formula in E2 that looks up the quantity and returns 'Bulk Rate' if 50+, otherwise 'Standard Rate'.
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 →