lookup two values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following

Size Depth Lenght
24 2 4
24 3 6
24 4 8
30 2 10

Cell A1 = 24, Cell B1 = 3. I want the result on C1 to be 6. What would be
the formula?
 
Size = A2:A5
Depth = B2:B5
Length = C2:C5

In C1 enter:

=SUMPRODUCT((A2:A5=A1)*(B2:B5=B1)*C2:C5)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
or in c1 vlookup(a1,a2:c5,3),b1 would be vlookup(a1,a2:c5,2).One caveat tho
vlookup will find the first value of 24 and give you the adjacent column.I
dont know if ragdyers sumproduct method shows the options or not
my example assumes your table is a2 c5 and you type in your size or return
it in a1
hope this helps a little!
 
Thank you all.. this solved my problem

RagDyer said:
Size = A2:A5
Depth = B2:B5
Length = C2:C5

In C1 enter:

=SUMPRODUCT((A2:A5=A1)*(B2:B5=B1)*C2:C5)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Click to expand...
 
Back
Top