Getting #N/A with OR function

[Chartman of the Bored]

Hi,

I'm using the OR function in conjunction with VLOOKUP. My three VLOOKUP functions reference cells in columns E, F, and G and try to find a match among a list of names in column S:

=OR(VLOOKUP(E2,$S:$T,2,0)="EAST",VLOOKUP(F2,$S:$T,2,0)="EAST",VLOOKUP(G2,$S:$T,2,0)="EAST")

I run into problems when the name in E correctly equals "EAST", but the name in F or G is not in the list in column S. In other words, I'm expecting a "TRUE" result, but instead I get #N/A.

Is there a way around this?

Thanks in advance

 

[Aladin Akyurek]

=INDEX(T:T,LOOKUP(9.99999999999999E+307,MATCH(E2:G2,S:S,0)))="EAST"

 

[Chartman of the Bored]

Thanks

Thanks Aladin. I had seen that trick a few years ago, but forgot about it.

Regards