Your equipment list keeps locations on the left and IDs on the right. Use the ID’s position to return the location without moving either column.

Match in column B and return from column A

Put North shelf, Tool cart, and Annex bin in A2:A4. Add K-18, K-24, and K-29 in B2:B4. Enter K-24 in D2 and use =INDEX($A$2:$A$4,MATCH(D2,$B$2:$B$4,0)) in E2. The exact match has position 2, which returns Tool cart.

MATCH finds K-24 at position 2 and INDEX reads Tool cart at position 2.

Illustrated leftward lookup. Align both input ranges by record.

Try the endpoints and an unknown ID

K-18 should return North shelf and K-29 should return Annex bin. K-99 has no match. If results appear shifted, compare the starting rows of both ranges. If an ID repeats, check which row is authoritative before trusting the first match.

The two endpoints return North shelf and Annex bin, while the absent ID K-99 has no match.

Illustrated checks. Resolve duplicate IDs before relying on the lookup.

For a lookup across two independent axes, see the room-and-session matrix example