Hello,
I have a spreadsheet where Column A in Sheet1 has a list of IDs that are separated by commas in a cell. In Sheet2, Column A has a list of unique IDs (not comma separated) that match Column A in Sheet 1. I would like to know how I can use XLOOKUP to find a match from within a comma separated cell in Column A of Sheet1, and once a match is found, to bring the value from Column B in Sheet2 over to Column B in Sheet1? Please see attached an example of the spreadsheet I am referring to.
I tried =XLOOKUP("*"&A2&"*",Sheet2!A:A,Sheet2!B:B,"") but that did not work.
Any ideas would be greatly appreciated.
Bookmarks