IF statement checking 4 conditions...HOW?

[AdRock]

I need to do an IF statement or something similar that can check for 4 condition if they all fail, display an error message

In cell A1 there is a list with values "1 Day" and "3 Day"

In cell A2 there is a list with values "Large" and "Small"

What i would like to check is these conditions:

A1 = 1 Day, A2 = Large
A1 = 1 Day, A2 = Small
A1 = 3 Day, A2 = Large
A1 = 3 Day, A2 = Small

I have a 2D lookups which will give me the value i want based on those conditions, i just need to know how to do an IF or whatever which will let me check all those condtions.

Any help appreciated

 

[CharlesChuckieCharles]

Check out AND and OR statements

IF(OR(AND(A1="1 Day",A2="Large"),AND(A1="1 Day",A2="Small"),AND(A1="3 Day",A2="Small"),AND(A1="3 Day",A2="Large")),"Do something Positive", "else something Negative")

 

[AdRock]

That makes sense but how would i apply a VLOOKUP for each condition?

I have 4 lookups each referencing either a different worksheet or different part of the worksheet.

 

[CharlesChuckieCharles]

Thats different

IF(AND(A1="1 Day",A2="Large"),VLOOKUP(yourkey,thatRange...),IF(AND(A1="1 Day",A2="Small"),VLOOKUP(yourkey,anotherRange...),...... etc

remember to close off with four brackets to close the IF statements

or

VLOOKUP(IF(AND(A1="1 Day",A2="Large"),yourkey,IF(AND(A1="1 Day",A2="Small"),yourkey....

 

[AdRock]

Works like a treat....thank you