Forum Discussion
Solved
Double Xlookup with Wildcards
Hi, I am having trouble with adding a wildcard to my Xlookup formula. When it is using the exact text "Deliver" or a cell reference it works fine but as soon as I try to add a * wildcard before or ...
You should specify the desired results.
=XLOOKUP(1,(Dates>=$E$1)*ISNUMBER(SEARCH($G$1,C4:Q4)),Dates,"no match",0,-1)
= XLOOKUP("*deliver*", IF(Dates>=TODAY(), Events), Dates, "In past", 2, 1)
Because each row could have multiple instances of "Deliver" it is ignoring everything in the past and only needs to return the next instance. I will try this out.