Sorry, I'm not understanding this!

Biff

"ozdemir" wrote in
message ...

Biff-

Thanks for the reply. I have not tried it yet but my first thought was
it won't work.

Sheet 1 has the following:

A1=Height
B1=Depth
C1=Width

E6=Price (which is the summation of various different cells in sheet
1)

I want sheet 2 to have those inputs listed as follows:

A1=Height (Constant)

B1:B10 (Range of Width values from 20-40)
A2:A10 (Range of Depth values from 20-40)

Then cell B2 would report the value of Sheet1!:E6, when
Sheet1!:A1=Sheet2!:$A$1, Sheet1!:B1=Sheet2!:A2, and
Sheet1!:C1=Sheet2!:B1. Does this make sense now? I want my sheet 1 to
do the calculations and then the result in E6 should be reported to my
table in sheet 2.

Thanks for your help!!!


--
ozdemir
------------------------------------------------------------------------
ozdemir's Profile:
http://www.excelforum.com/member.php...o&userid=29426
View this thread: http://www.excelforum.com/showthread...hreadid=491361