"Match" not returning results-CodePudding

I am trying to look for any match from column A in column D, then if so do something else.

Having problems getting my match to work and not sure why.

I have this forumla in column C.

=IFERROR(IF(MATCH("|"&A2&"|",D$1:D$6,0),"True","False"),"Error")

Not sure if it matters but my values in column A and D are from other formulas in those cells.

CodePudding user response：

Just as a variant you can use find():

Then use iferror() and if() to control what you need for the results.

So added more of your data:

CodePudding user response：

I ended up going with this.

=ISNUMBER(MATCH("*|"&A2&"|*",D$1:D$6,0))

Thanks again.