ISNUMER and MATCH: on two columns

[itr674]

is it possible to use ISNUMBER and MATCH on two adjacent columns.

I want to use ISNUMBER and MATCH to return true i the formula finds A,B,C,D,,F,G,H,I, or J in either of the ranges.

Range A1:A5 house A,B,C,D,and E

Range B1:B5 houses F,G,H,I,and J

 

[AlanY]

you can do the match twice like this, with number to match in C1

=ISNUMBER(IFERROR(MATCH(C1,A1:A5,0),IFERROR(MATCH(C1,B1:B5,0),"")))

 

[itr674]

thank you, I think this will work.

 

[AlanY]

you're welcome