Help with complex "IF" formula !!!

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

Luke M

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","")
 
S

Sam Wilson

=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","")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with an IF Formula 5
Help with VLOOKUP & MATCH formula 5
Vlookup and If statement help 1
Iserror with if(or & Vlookups 5
Help with IF and VLookup Match Statement 1
help with simple formula 1
Help with If and Vlookup Statement 1
Tough one - Sum and IF with multiple referencing (array) 5

Top