Forum Discussion

mpenley's avatar
mpenley
Copper Contributor
Sep 17, 2020
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...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 17, 2020

    mpenley 

    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's avatar
SergeiBaklan
Diamond Contributor
Sep 17, 2020

mpenley 

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.

  • mpenley's avatar
    mpenley
    Copper Contributor
    Sep 17, 2020

    SergeiBaklan you nailed it with the isnumber(search! That did the trick. Thank you for your help. 

Resources