Kevin Rodriguez wrote:
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

Hi Kevin,

I think that without having a look to the file it's quite impossible to say
why the function didn't work...

Maybe there's some problem with your data table...

If you like you could upload an example to www.savefile.com or
www.rapidshare.de...


--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy