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),S heet2!D2,0)

Regards,
Fred

"susanmck" wrote in message
...
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" wrote:

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" wrote in message
...
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.

.