You're an HR analyst pulling the manager-of-record for three employees flagged in a workforce audit. Columns A–D hold the org master — and notice the column order: Manager Name (A) appears before Employee ID (B).
That ordering is the trap. VLOOKUP can't return a column to the left of its lookup key — Manager (A) is left of EmployeeID (B). INDEX/MATCH (or XLOOKUP) handles this pattern natively because INDEX doesn't care which side of MATCH the return column lives on.
Three lookup IDs are pre-populated in column F.
Your task:
- In column G (Manager), write an INDEX/MATCH formula that returns the manager's name for each employee ID.
- The formula must be drag-down friendly.
Graded cells: G2, G3, G4.
Open this problem on a desktop to attempt it.