Matching cell content against selected cells - not range

Hi,

I'm trying to use the below formula to to return "true" when text in cell (M2) matches text in selected cells on same row (A2, E2, and G2)
However, all formulas I found online that serve this purpose deal with cell range only, not predetermined cells with exclusions.

Formula:

=IF(ISNUMBER(MATCH(M2,A2:G2,0),TRUE,FALSE) (This will match all cells between A2 and G2 against M2)

Any help with reforming this formula to match selected cells only in-between that range (A2, E2 and G2)?

Many thanks in advance,,

Thank you for your response.
I don't want to return "True" when all text in the three cells match text in (M2) at same time. I only need to check if any one of the three cells (or any given cells that are not necessarily in a connected range) matches text on M2, to return "True" using the exact if statement above.

I appreciate your help

Originally Posted by Lemice

Hello,

Assuming you only want to check if M2 matches the text in A2, E2 and G2 at the same time, you can use this

Please Login or Register  to view this content.

Thanks for your effort.
As I mentioned, I need this to be integrated into the formula =IF(ISNUMBER(MATCH("put selected cells here",0),TRUE,FALSE) so I could customize returned value when True, False

is there anyway to do this?

Originally Posted by Lemice

In case you want it to return TRUE when the text in M2 matches at least one of the text in 3 cells, you can use this then

Please Login or Register  to view this content.

If you want to check it against more cell, simply add more logic statement to it.

Sixthsense,,,
Sorry I didn't notice your solution earlier!!
That's exactly what I'm looking for, it works perfectly!!

Thank you so much

Originally Posted by :) Sixthsense :)

May be this..

Formula:

Please Login or Register  to view this content.