Compare columns between workbooks

[asaravelli1234]

Hello everyone-

I have multiple spreadsheets each with a column that lists unique identifiers all with the same leading 3 letters, then several digits- I would like see if any of the whole identifiers (ABCXXXXX) listed in Spreadsheet A are present anywhere in the list of identifiers in Spreadsheet B, C, D, E and F. I am hoping there is an easy way to highlight and see what identifiers Spreadsheet A shares with any of the other lists. Is there anything that I can try to easily do this? Thanks very much in advance for your help

 

[alansidman]

Look at using Power Query, called Get and Transform in 365. You will want to bring each table into PQ editor. Then perform a left outer join to determine what is in first sheet that is in the second sheet.