@John the Personal.xlsb macro workbook is stored in C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart for Windows 10. You may be confusing it with the Windows 11 location.

@Rahmoud I'll have to ask the tech when they open tomorrow and get back to you.

I appreciate both answers, however this one allowed for a precise match in the event of similar text values. I found with using LARGE/AGGREGATE & FIND it would mix up MIAG with MIA.

@Mockman - I'm trying to retrieve the address of the cell from the lookup value. I have another range further down the tab that uses the UNIQUE formula to pull these text values from their respective tabs, then I use VBA to transfer them to that table. I suppose some combination of ADDRESS with some form of XLOOKUP or INDEX-MATCH would do it, but I can't get the right combo.

Hi, yes I did. Unfortunately, that function only seems to export as either a PDF or XPS format.