Level 2Working Across TabsPractice, 3 min
XLOOKUP from a routing tab
The task
New leads need an owner. The routing table lives on the Territories tab. In Leads!C2, look up every lead's state at once and return the owner, with Unassigned for states that aren't in the table.
The data, 2 tabs
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | |
|---|---|---|---|
| 1 | Lead | State | Owner |
| 2 | Bean There Coffee | TX | |
| 3 | Sir Loin Steakhouse | IL | |
| 4 | Northwind | CA | |
| 5 | Knead to Know Bakery | OH | |
| 6 | Harbor & Co | FL | |
| 7 | Cobalt Labs | NY |
| A | B | |
|---|---|---|
| 1 | State | Owner |
| 2 | CA | Maya |
| 3 | TX | Theo |
| 4 | NY | Priya |
| 5 | IL | Jonah |
| 6 | FL | Lena |