Thread: OR
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arno Arno is offline
external usenet poster
 
Posts: 60
Default 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