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. :-(
|