lookup two values
 

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!
==============================================


"nemesis2" wrote in message
...
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?

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!

--
paul
remove nospam for email addy!



"RagDyer" wrote:

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!
==============================================


"nemesis2" wrote in message
...
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?

Thank you all.. this solved my problem

"RagDyer" wrote:

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!
==============================================


"nemesis2" wrote in message
...
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?