OR

[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

 

[Bob Phillips]

Why start a new thread, continue in the other.

Anyway, I get TRUE in this situation.

 

[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

 

[Eduardo]

Hi Arno,
Use this

=+IF(OR(b10="AIB",b10="Moody"),b10,"")

 

[Arno]

Thank you Eduardo !! It works

Hi Arno,
Use this

=+IF(OR(b10="AIB",b10="Moody"),b10,"")

 

[Eduardo]

Hi Arno,
Please if it works rate it as it was helpfull. thank you