You're a logistics analyst tagging outbound packages with their delivery region. Columns A–B contain 10 packages and their destination ZIPs (stored as integers — leading zeros stripped, so Boston's 02101 is the number 2101).
Your task:
- In column C (Region), return the delivery region for each ZIP using approximate-match VLOOKUP (the range lookup form).
Use this region table — note that it must be sorted ascending for approximate match to work:
| ZIP ≥ | Region |
|---|
| 0 | Northeast |
| 30000 | Southeast |
| 60000 | Central |
| 80000 | West |
So a ZIP of 75201 lands in Central (≥ 60000 and < 80000), and 90210 lands in West (≥ 80000).
Critical: the 4th argument of VLOOKUP must be TRUE (or omitted) for approximate match.
Graded cells: C2, C5, C8.
Open this problem on a desktop to attempt it.