In B2 =SUMPRODUCT(--($A$1:$A$100=$A2),--(B1:100=B$1),$C$1:$C$100)

A2 = chair
B1 = Black



"Kevin" wrote:

How do I populate a cell using another worksheet as a reference?

For example, if Sheet1 looks like this:

A B C
1 Part Color Price
2 Desk Black 200.00
3 Chair Black 100.00
4 Lamp Gold 50.00

Sheet2 looks like this:

A B C
1 Black Gold
2 Chair 100.00 150.00
3 Lamp 35.00 50.00
4 Desk 200.00 300.00

I want column C in Sheet1 to pull the price depending on the two crietria.

Any ideas?

Thanks.

Kevin