How to use a wildmatch function inside a Match function

[sudms]

Hello Guys,

I am trying to replace nested if with Pick Match function, but I am stuck at using Wildmatch inside the Match function like,

pick(
     Match( -1,
           Subjects = 'Stat',
           WildMatch(Name,'YYY*')
     )+1
,'NA'
,'Low'
,'High'
)

Here if you see my 2nd condition is not working.

Any help would be appreciated.

[Or]

Wildmatch() never returns -1. It returns the number of the match, or 0 if no match was found, same as Match().

[marcus_sommer · Accepted solution]

Just add a comparing to the wildmatch(), like:

pick(
     Match( -1,
           Subjects = 'Stat',
           WildMatch(Name,'YYY*') > 0
     )+1
,'NA'
,'Low'
,'High'
)