Hello everyone,
I would like to find a formula like XLOOKUP which looks up say, column A from Sheet 1 to see if there's a match in Column A from Sheet 2, and returns column B from Sheet 2. The problem is, Column A from both worksheets have values which are separated by commas.
See attached my example below. I would like to know if any of the values in column B of Sheet 1 matches any of the values in Column B of Sheet 2, then return Column A from Sheet 2 to Column C from Sheet 1, if that makes sense!?
Thanks in advance for your help!
Bookmarks