Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
How do I LOOKUP text values | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Lookup Function - Specific Values | Excel Worksheet Functions | |||
Need help with lookup and comparing values | Excel Worksheet Functions |