An analyst's target-salary lookup works but uses a clumsy two-step chain with a helper column:
F2: =MATCH(C2, {"Junior","Mid","Senior","Lead","Principal"}, 0) ← helper, returns 1–5
D2: =VLOOKUP(F2, $H$2:$I$6, 2, FALSE) ← uses helper
Where H2:H6 = {1,2,3,4,5} and I2:I6 = the salaries below.
Your task:
- Refactor into a single formula in column D that doesn't need the helper column F. Use XLOOKUP with the grade names directly as the lookup array.
Salary band:
| Grade | Target Salary |
|---|
| Junior | $60,000 |
| Mid | $80,000 |
| Senior | $110,000 |
| Lead | $145,000 |
| Principal | $185,000 |
Graded cells: D3, D5, D7.
Open this problem on a desktop to attempt it.