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))="","Y ES",IF(OR(INDEX(Sheet1!T:T,MATCH(B7,Sheet1!A:A,0)) ={"ATA115115","BBDD101101"}),"YES","NO"))

Biff

"dbl" wrote in message
...
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))="","Y es",IF(OR(INDEX(Sheet1!
T:T,MATCH(B7,Sheet1!A:A,0),1)={"ATA115115","BBDD10 1101"}),"Yes","No"))

Hope this helps!

In article ,
"dbl" 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

Thanks Biff & Domenic that works fine.

Regards Bob
"Biff" wrote in message
...
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))="","Y ES",IF(OR(INDEX(Sheet1!T:T,MATCH(B7,Sheet1!A:A,0)) ={"ATA115115","BBDD101101"}),"YES","NO"))

Biff

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