OR
 

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

OR
 

Why start a new thread, continue in the other.

Anyway, I get TRUE in this situation.

--
__________________________________
HTH

Bob

"Arno" wrote in message
...
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

OR
 

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

"Arno" wrote:

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

OR
 

Hi Arno,
Use this

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

"Arno" wrote:

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

OR
 

Thank you Eduardo !! It works

"Eduardo" wrote:

Hi Arno,
Use this

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

"Arno" wrote:

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

OR
 

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

"Arno" wrote:

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