Excel 2007 Formulas

[susanmck]

I am trying to create a logic formula doing the following.

IF B9 = A, and C9 = B, then H9 = C

I have set up the "A's, B's, and C's" on sheet 2. B9 & C9 on sheet 1 are
combo boxes receiving their lists from sheet 2.

Any help would be much appreciated.

 

[Fred Smith]

Is this what you are looking for, entered in H9:
=if(and(sheet1!b9="A",sheet1!c9="B"),"C","whatever you want when not true")

Regards,
Fred

 

[susanmck]

Hello Fred,

It is not quite working it is filling the cell with FALSE.

This is how I translated the formula you provided:
=IF(AND(Sheet1!B9="Sheet2!A2",Sheet1!C9="Sheet2!B2"),"Sheet2!D2","0")

This is sheet 1:
QTY Size Style Description Amount Price

There is Combo box with items listed from sheet 2 under Size & Style

On sheet 2:
Sizes listed in Column A (2-18)
Styles listed in Column B (2-9)
Amounts (in dollars) listed in Column D (2-67)

There are 66 possible combinations.

I'm not sure if this kind of equation can even exist without being a mile
long, but if it can then great.

I appreciate your assistance!

 

[Fred Smith]

Why are you putting your data and cell addresses in quotes? That turns them
into text. Try the following:
=IF(AND(Sheet1!B9=Sheet2!A2,Sheet1!C9=Sheet2!B2),Sheet2!D2,0)

Regards,
Fred

 

[susanmck]

I used the formula you first gave me that had quotation marks. i just tried
it without quotes but it still gives me false. The more I look at this the
more I think it is not going to work. I have 66 possible combinations.

Thank you!