Forum Discussion
XLOOKUP Formula Help needed in Excel
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)
Patrick2788 Good Morning, Here is the sheet. You will see that the tab called "For Commission Receipts" is the one with all the data and I wanted to start off by having all commissions belonging to Morgan Pratt appear on his sheet "MPratt_Feb", and follow with the rest of the team with their own spreadsheet.
Here's the formula:
=FILTER(Receipts,Names=$A$1,"")Receipts and Names are dynamic named items I've created. Also, you'll want to enter Stigman's full name in A1 of that sheet. There's no Stigman records yet but that will insure FILTER pulls them when available.
- OMG this really helped alot. One other question, taking Morgan Pratt for example. Since his name appears on Column V AND Column X, the formula only captured his commission when his name appeared on Column V but not the one under Column X.
As for Clayton Stigman, his name appears on Column X and Column Z only, When I type in his full name, nothing appeared.Please see updated attached.
Patrick2788 You helped me a month ago when I did a February Commissions report and here I am again in March doing the same thing. The problem here is that the formula you gave me to use to show the commission summary for each sales person did not work. I have attached the file and the Green Tabs, is the problem I am having. What happened that I cannot get the information to populate with the formula you gave me? HELP!
Thank you,
Sandra