Getting #N/A with OR function

Chartman of the Bored

Board Regular
Joined
Apr 24, 2002
Messages
83
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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,109,033
Messages
5,526,363
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top