Help with complex "IF" formula !!!

  • Thread starter Thread starter Iriemon
  • Start date Start date
I

Iriemon

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. :-(
 
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),Lookup!$A$3:$C$465,3,FALSE)="",$D2<25)),"Immediate","")
 
=if(OR(AND(VLOOKUP(LEFT($C2,4),Lookup!$A$3:$C$465,3,FALSE)="YES",$D2<100),AND(VLOOKUP(LEFT($C2,4),Lookup!$A$3:$C$465,3,FALSE)="",$D2<25)),"Immediate","")
 
Back
Top