Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
2nd part of formula not working
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 |
#3
|
|||
|
|||
2nd part of formula not working
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 |
#4
|
|||
|
|||
2nd part of formula not working
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping one part of a formula same, but change other cell ref? | Excel Discussion (Misc queries) | |||
Fomatting part of a formula to be Bold font | Excel Worksheet Functions | |||
Part Number/Qty Consolidations | Excel Discussion (Misc queries) | |||
Bold part of formula results | Excel Discussion (Misc queries) | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) |