Forum Discussion
XLOOKUP Challenge
Hey folks, I've got a problem that I don't know how to solve, with a spreadsheet. The source sheet that I'm trying to work with, contains a column for "Sales Order Number", that contai...
Without seeing the data, I offer this solution:
=XLOOKUP("*"&E2:E4&"*",A2:A5,B2:B5,"",2)
Hey Patrick, Here's a segment of the sheet for illustration:
So, from a different, call it "master" sheet, which contains a list of all SO#'s, I'm trying to use a single SO# as the first parameter in the XLOOKUP, or "what to look for", and using column "G" as the range to search. Then, I'm wanting to return the values in columns "A" and "B", back to the master sheet. But for me, as there are multiple SO#'s in each cell in column G, I'm getting errors. I hope this clarifies the problem sufficiently, and I look forward to what this brain trust suggests. Thanks again. Jeff