Help with complex "IF" formula !!!
I am trying to write a single "IF" statement that uses the following two
conditions: AND(VLOOKUP(LEFT($C2,4),Lookup!$A$3:$C$465,3,FALSE )="YES",$D2<100) or AND(VLOOKUP(LEFT($C2,4),Lookup!$A$3:$C$465,3,FALSE )="",$D2<25) if either of these 2 conditions is met, place "Immediate" in cell N2, otherwise leave it blank. I seem to be missing a parentheses or something. :-( |
Help with complex "IF" formula !!!
I think this is what you want?
=IF(OR(AND(VLOOKUP(LEFT($C2,4),Lookup!$A$3:$C$465, 3,FALSE)="YES",$D2<100),AND(VLOOKUP(LEFT($C2,4),Lo okup!$A$3:$C$465,3,FALSE)="",$D2<25)),"Immediate", "") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Iriemon" wrote: I am trying to write a single "IF" statement that uses the following two conditions: AND(VLOOKUP(LEFT($C2,4),Lookup!$A$3:$C$465,3,FALSE )="YES",$D2<100) or AND(VLOOKUP(LEFT($C2,4),Lookup!$A$3:$C$465,3,FALSE )="",$D2<25) if either of these 2 conditions is met, place "Immediate" in cell N2, otherwise leave it blank. I seem to be missing a parentheses or something. :-( |
Help with complex "IF" formula !!!
=if(OR(AND(VLOOKUP(LEFT($C2,4),Lookup!$A$3:$C$465, 3,FALSE)="YES",$D2<100),AND(VLOOKUP(LEFT($C2,4),Lo okup!$A$3:$C$465,3,FALSE)="",$D2<25)),"Immediate", "")
"Iriemon" wrote: I am trying to write a single "IF" statement that uses the following two conditions: AND(VLOOKUP(LEFT($C2,4),Lookup!$A$3:$C$465,3,FALSE )="YES",$D2<100) or AND(VLOOKUP(LEFT($C2,4),Lookup!$A$3:$C$465,3,FALSE )="",$D2<25) if either of these 2 conditions is met, place "Immediate" in cell N2, otherwise leave it blank. I seem to be missing a parentheses or something. :-( |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com