Level 2LookupsPractice, 3 min
XLOOKUP the account owner
The task
Sales wants to know who owns Brightline. In F2, use
XLOOKUP to find the account in column B and return the owner from column A.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Owner | Account | Plan | Account | Owner | |
| 2 | Maya | Northwind | Pro | Brightline | ||
| 3 | Theo | Cobalt Labs | Starter | |||
| 4 | Priya | Brightline | Enterprise | |||
| 5 | Jonah | Fieldstone | Pro | |||
| 6 | Lena | Harbor & Co | Enterprise | |||
| 7 | Maya | Quillworks | Starter |