Re: Vlookup with to parameters

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Sat, 11 Jun 2005 19:54:14 +0300, "Amnon Wilensky" <wilensky@xxxxxxxxxxx>
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
.

Relevant Pages

  • Re: core dimensions needed
    ... diameter to propelant diameter ... at the top of the tube for delay and header. ... You don't have to be exact to make it work - just vary your ... up diluting your fuel with charcoal to stop CATOs. ...
    (rec.pyrotechnics)
  • Re: square in circle?
    ... how about measuring the diameter and multiplying by 3.14. ... Yah But 3.14 isn't exact. ... that circle to within a few millimeters of accuracy. ... once you get past a few digits the accuracy is irrelevant to ...
    (rec.woodworking)
  • Parts for teawagon wheels
    ... I have 2 grooved wheels where the rubber tire has deteriorated. ... looking for round solid material about 3/8" diameter by the foot to ... Prev by Date: ...
    (rec.woodworking)
  • Question about float-zone
    ... Why in the float zone process the molten crystal has a diameter ... inferior than solid crystal? ... Prev by Date: ...
    (sci.engr.semiconductors)
  • Re: Use of Interior.ColorIndex
    ... If A14 doesn't contain 1 and progress by 1 in subsequent rows, ... > liquidhot's Profile: ... Prev by Date: ...
    (microsoft.public.excel.programming)