Forum Discussion
Solved
XLOOKUP Formula Help needed in Excel
Help needed please... I need to search for a name (i.e. Joe Smith) in columns V & X on one spreadsheet (see below) and have the CK NO on this spreadsheet be applied to another worksheet called Co...
Join the lookup columns and make the XLOOKUP run a wildcard match.
For example (A1 being "Joe Smith")
=XLOOKUP("*"&A1&"*",Sheet1!$V$2:$V$5&Sheet1!$X$2:$X$5,Sheet1!$A$2:$A$5,,2)
Join the lookup columns and make the XLOOKUP run a wildcard match.
For example (A1 being "Joe Smith")
=XLOOKUP("*"&A1&"*",Sheet1!$V$2:$V$5&Sheet1!$X$2:$X$5,Sheet1!$A$2:$A$5,,2)
The formula worked but when I want it to look up the next commission for this sales rep, it repeats the same one instead of pulling in the next one.