Forum Discussion
Solved
Trouble with XMATCH using multiple criteria and a wildcard
I have a dynamic spreadsheet where formula input data is designed to change based on user inputs. Which leads to many complicated index matches pulling data from source data. Below is the formula i a...
But you have no wildcard for the XMATCH here. Your formula is like
XMATCH(1, condition, ...
If use wildcard it shall be where 1 is. In condition you compare texts like "Austin*" = "Austin Something" and it's never returns TRUE since here wildcard doesn't work.
As variant you may use ISNUMBER(SEARCH(... in condition with exact match for XMATCH.
SergeiBaklan you nailed it with the isnumber(search! That did the trick. Thank you for your help.
mpenley , you are welcome