You're an IT analyst preparing a license-tier summary. Columns A–C contain 6 customer accounts with their headcount and plan. You need to look up two values per customer — monthly base cost and SLA response hours — from the same plan reference.
Your task:
- In column D (Monthly Cost), return the base cost for each plan.
- In column E (SLA Hours), return the SLA response hours for each plan.
Plan reference table:
| Plan | Base Cost | SLA Hours |
|---|
| Starter | $50 | 48 |
| Pro | $200 | 24 |
| Business | $500 | 8 |
| Enterprise | $1000 | 4 |
You'll need two formulas (one for column D, one for column E) — both lookups against the same plan column.
Graded cells: D2, E2, D3, E3, D7, E7.
Open this problem on a desktop to attempt it.