A junior analyst built a department-lookup formula that returns wrong values for some employees:
=VLOOKUP(B2, $F$2:$G$6, 2)
Both column B (Dept Code) and the reference table look correct on inspection. The values are almost right — but enough are off that accounting bounced the report.
The bug: the 4th argument was omitted, which defaults to TRUE (approximate match). On unsorted text codes, VLOOKUP-TRUE returns whatever row the binary-search-style scan happens to land on — sometimes correct by luck, sometimes not.
Your task:
- Build the reference table on the sheet (e.g., F2:G6) using the values below.
- Write a corrected formula in column C that returns the right department for every row.
Reference (note: deliberately listed in arrival-order, not sorted):
- D-401 → Sales
- D-105 → Engineering
- D-789 → Operations
- D-203 → Marketing
- D-560 → Finance
Graded cells: C2, C6, C8.
Open this problem on a desktop to attempt it.