Practice challenge
Look up a customer tier
#12
3 attempts remaining
IntermediateLookup tablesTarget C2
A customer list needs the tier from a small lookup table on the right.
Write a formula for C2 that looks up the tier for the customer ID in A2.
Look up a customer tier
Swipe horizontally to view the full table.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| # | Customer ID | Name | Tier | Lookup ID | Lookup tier |
| 2 | C-104 | River Co | blank | C-104 | Gold |
| 3 | C-205 | North Ltd | blank | C-205 | Silver |
| 4 | C-310 | Blue Shop | blank | C-310 | Bronze |