The asset catalog should give one shelf for each ID. A regular first-match lookup can hide a duplicate. Use DGET when a match should resolve to exactly one record.

Set up the database and the criteria

Put Asset ID and Location in A1 and B1, with the rows beneath them. Put the same Asset ID header in H1 and enter numeric 341 in H2. If the sample catalog in A1:B5 has one row for 341 at Shelf C, this returns Shelf C:

=DGET(A1:B5,"Location",H1:H2)

An asset catalog and criteria cell show a single match for ID 341 with location Shelf C.

Illustrated single match. Use the exact same header in the criteria range and the catalog.

Test the two ways a lookup can fail

In a copy, add a second matching ID within the database range. A duplicate produces #NUM!. Test an ID absent from the catalog for #VALUE!. If the result is unexpected, first check the headers, the numeric type and the extent of the database range.

The example distinguishes one match from duplicate and missing IDs using DGET outcomes.

Illustrated result check. Investigate the reason for an error before treating it as a blank location.

Keep those errors visible while investigating duplicates or missing records. Verify the source rows before publishing a location from the catalog.

Microsoft’s DGET function reference.