| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
