OR

A

Arno

Hello,

In C1 I have =OR(B10="MOODY",B10="AIB")

PROBLEM:
B10 (see below) is a Vlookup and it is preventing C1 to return the name of
the agency: AIB or MOODY - Instead I get FALSE

Hours Agency
70.00 AIB
80.00 MOODY
40.00
40.00
40.00
40.00
40.00
40.00
70.00 AIB (B10)

Can you Please help to have the name of the agency in C1

Thank you - Arno
 
B

Bob Phillips

Why start a new thread, continue in the other.

Anyway, I get TRUE in this situation.
 
A

Arno

Hi Bob,

New thread because I wanted to get an ansewr with a simpler example.

However I still need to get a name out of C1, true or false are no useful
for me.

Thanks anyway Arno
 
Top