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