XLOOKUP's return array isn't limited to one column — point it at three columns together and the one match it finds spills a whole row of details sideways, instead of three separate lookups that could each land on a different row if the roster ever gets resorted.
You handle IT provisioning tickets for an onboarding team, and the HR roster keeps each employee's name, department and start date in three separate columns. A ticket only ever carries an employee ID, so before anything can be provisioned you need to know who that ID belongs to. In B2, write one XLOOKUP that matches the ID in column A against the roster's ID column in E2:E5 and returns all three of the roster's other columns, F2:H5, at once — let the result spill into B2:D2 rather than writing three separate lookups. Fill in rows 2 through 5.
Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Employee ID | Name | Department | Start Date | Employee ID | Name | Department | Start Date |
| 2 | E1042 | E1015 | Priya Natarajan | Finance | 3/4/2019 | |||
| 3 | E1078 | E1042 | Marcus Webb | Logistics | 6/12/2021 | |||
| 4 | E1015 | E1078 | Dana Brooks | Marketing | 1/9/2023 | |||
| 5 | E1091 | E1091 | Felix Okafor | Engineering | 9/22/2020 |
XLOOKUP(A2,$E$2:$E$5,$F$2:$H$5) finds E1042 second among the roster's IDs and returns not one cell from that row but the entire slice of it the return array spans — Marcus Webb, Logistics and 6/12/2021 — because F2:H5 was handed to it three columns wide rather than one. That three-wide result is itself a small array, which is why typing the formula once into B2 is enough to fill C2 and D2 too: neither of those two cells has anything typed into it directly for a learner to get wrong. Writing =XLOOKUP(A2,$E$2:$E$5,$F$2:$H$5) once, instead of three near-identical lookups each pointed at a single column of the roster, is also what keeps Name, Department and Start Date from drifting out of row with each other — all three come from the one match against the one ID, not three separate matches that could each land on a different row if the roster were ever resorted.