Hi!

You have some extra unnecessary ( ) but that's not the problem.

Your formula is "strange" so I'm guessing the problem is with the lookup.

=OR((LEFT(E87,2)="M-"),(VLOOKUP(E87,$Q$2:$Q$10,1,FALSE)=1))

First, you're testing for a TEXT value with LEFT but then in the LOOKUP
you're testing for =1 which implies that E87 is a NUMERIC value.. A TEXT
value will evaluate to be =1. I think you need to tell us what's in Q2:Q10
and what are the possible entries in E87.

Here's your formula wilthout the extra ( ):

=OR(LEFT(E87,2)="M-",VLOOKUP(E87,$Q$2:$Q$10,1,FALSE)=1)

Biff

"Kevin Rodriguez" <Kevin wrote in
message ...
I'm trying to use the OR function in a CF formula without success. The
formula I'm using is:

=OR((LEFT(E87,2)="M-"),(VLOOKUP(E87,$Q$2:$Q$10,1,FALSE)=1))

For some reason, the VLOOKUP is working, but the LEFT doesn't work. I
pulled out the Left into a cell and it works fine. But for some reason,
within the OR function in the CF it doesn't.

Any help is appreciated.

Kevin Rodriguez