OR MATCH only returns FALSE when using a table array

[scottyperry]

I am comparing fields on multiple sheets. When I use =OR(ISNUMBER(MATCH(B3,KNDQA!B28:M29,0))) to match a value on a separate sheet it always returns FALSE regardless of the exact match or not. I am not sure what the issue is. It only returns true if my array is a single cell.

Please help!

Feb_13_all_universes.xlsx

[Pepe Le Mokko]

What do you use OR for in this formula, as there is only one condition ?
This range KNDQA!B28:M29 is empty... ?

[ChemistB]

Match only works in a single column or a single row, i.e Match(B3, B28:B50,0) or MATCH (B3, B28:M28,0)

Not sure exactly what you are trying to do (as I don't know what sheet you're putting the formula in and there's nothing in KINDQA!B28:M29) but try

=SUMPRODUCT(--(KNDQA!B28:M29=B3))>0

[scottyperry]

ChemistB

Thanks that seems to have worked.

I want to see what values are present in the other sheets by using TRUE/FALSE to identify them.

If there is a better way I would love to know but your =SUMPRODUCT seems to have done it.