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)
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.

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.



