2nd part of formula not working

Hi I have the following formula:

=IF(OR(INDEX(Sheet1!C:C,MATCH(B7,Sheet1!A:A,0))=""),"YES",IF(INDEX(Sheet1!T:T,MATCH(B7,Sheet1!A:A,0),1)={"ATA115115","BBDD101101"},"YES","NO"))

It works fine until Sheet1!T:T,MATCH(B7 where it finds "BBDD101101" part
where I need it to input "YES" I only get a "NO"

If I delete the BBDD101101" part then the formula works fine, so has anyone
got any idea's to what I am doing wrong? How do I get the BBDD101101 to
return a "YES"?

Any help would be very much appreciated.

Bob

Hi!

You have OR in the wrong location. Put it inside the second IF:

=IF(INDEX(Sheet1!C:C,MATCH(B7,Sheet1!A:A,0))="","YES",IF(OR(INDEX(Sheet1!T:T,MATCH(B7,Sheet1!A:A,0))={"ATA115115","BBDD101101"}),"YES","NO"))

Biff

"dbl" <dbl@tesco.net> wrote in message
news:ehHl7U00FHA.1564@tk2msftngp13.phx.gbl...
> Hi I have the following formula:
>
> =IF(OR(INDEX(Sheet1!C:C,MATCH(B7,Sheet1!A:A,0))=""),"YES",IF(INDEX(Sheet1!T:T,MATCH(B7,Sheet1!A:A,0),1)={"ATA115115","BBDD101101"},"YES","NO"))
>
> It works fine until Sheet1!T:T,MATCH(B7 where it finds "BBDD101101" part
> where I need it to input "YES" I only get a "NO"
>
> If I delete the BBDD101101" part then the formula works fine, so has
> anyone got any idea's to what I am doing wrong? How do I get the
> BBDD101101 to return a "YES"?
>
> Any help would be very much appreciated.
>
> Bob
>

Thanks Biff & Domenic that works fine.

Regards Bob
"Biff" <biffinpitt@comcast.net> wrote in message
news:ekt9dk00FHA.3896@TK2MSFTNGP10.phx.gbl...
> Hi!
>
> You have OR in the wrong location. Put it inside the second IF:
>
> =IF(INDEX(Sheet1!C:C,MATCH(B7,Sheet1!A:A,0))="","YES",IF(OR(INDEX(Sheet1!T:T,MATCH(B7,Sheet1!A:A,0))={"ATA115115","BBDD101101"}),"YES","NO"))
>
> Biff
>
> "dbl" <dbl@tesco.net> wrote in message
> news:ehHl7U00FHA.1564@tk2msftngp13.phx.gbl...
>> Hi I have the following formula:
>>
>> =IF(OR(INDEX(Sheet1!C:C,MATCH(B7,Sheet1!A:A,0))=""),"YES",IF(INDEX(Sheet1!T:T,MATCH(B7,Sheet1!A:A,0),1)={"ATA115115","BBDD101101"},"YES","NO"))
>>
>> It works fine until Sheet1!T:T,MATCH(B7 where it finds "BBDD101101" part
>> where I need it to input "YES" I only get a "NO"
>>
>> If I delete the BBDD101101" part then the formula works fine, so has
>> anyone got any idea's to what I am doing wrong? How do I get the
>> BBDD101101 to return a "YES"?
>>
>> Any help would be very much appreciated.
>>
>> Bob
>>
>
>

Try...

=IF(INDEX(Sheet1!C:C,MATCH(B7,Sheet1!A:A,0))="","Yes",IF(OR(INDEX(Sheet1!
T:T,MATCH(B7,Sheet1!A:A,0),1)={"ATA115115","BBDD101101"}),"Yes","No"))

Hope this helps!

In article <ehHl7U00FHA.1564@tk2msftngp13.phx.gbl>,
"dbl" <dbl@tesco.net> wrote:

> Hi I have the following formula:
>
> =IF(OR(INDEX(Sheet1!C:C,MATCH(B7,Sheet1!A:A,0))=""),"YES",IF(INDEX(Sheet1!T:T,
> MATCH(B7,Sheet1!A:A,0),1)={"ATA115115","BBDD101101"},"YES","NO"))
>
> It works fine until Sheet1!T:T,MATCH(B7 where it finds "BBDD101101" part
> where I need it to input "YES" I only get a "NO"
>
> If I delete the BBDD101101" part then the formula works fine, so has anyone
> got any idea's to what I am doing wrong? How do I get the BBDD101101 to
> return a "YES"?
>
> Any help would be very much appreciated.
>
> Bob