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...
I would need to see a sample of the data, but XLOOKUP is capable of performing 'wildcard' matches.
= XLOOKUP("*"& SOrequired &"*", SOnumbers, SOdata,"not found",2)using a value of 2 as the 'match_mode'.