Merged Cells with XLOOKUP Help

Hello!   I have this workbook (not mine), that has over 10,000 entries. I need to do a simple xlookup to match a location number to a location name. The problem is, throughout the entire workbook, ...