On Sat, 11 Jun 2005 19:54:14 +0300, "Amnon Wilensky"
wrote:
Hi
I am trying to find a value in a table by using two parameters as shown in
the table below:
Diameter Height price
80 30 100
80 60 200
80 100 300
100 30 150
100 60 250
100 100 350
125 30 400
125 60 500
125 100 600
In A12 I want to input the diameter
In A13 the input the height
In A14 to have the result
Example:
A12=80
A13=100
A14 (the result) will give "300"
I tried to use Vlookup combine with Index and match without success.
Any help?
Thanks,
Amnon
If the columns of your table are NAME'd Diameter, Height and Price, then:
=SUMPRODUCT((A12=Diameter)*(A13=Height)*Price)
will give you the result. However, it will return a "0" if the matches are not
exact. What do you want to do in that instance?
--ron
|