Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get multiple values in vlookup?
hello.
i am a project planner and doing a quantity analysis whose spreadsheet is huge & simalar to this eg : code quantity a 12 s 3 d 45 total A = 12 a 6 g 67 a 7 d 88 when i tried the vlook up finction =VLOOKUP(A2,A1:B8,2,FALSE) it gives me the value 12 instead of the summation (12+6+7= 25) is dere any way i can get multiple values using vlokup. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get multiple values in vlookup?
=SUMIF(A1:A8,A2,B1:B8)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "pvuv" wrote in message ... hello. i am a project planner and doing a quantity analysis whose spreadsheet is huge & simalar to this eg : code quantity a 12 s 3 d 45 total A = 12 a 6 g 67 a 7 d 88 when i tried the vlook up finction =VLOOKUP(A2,A1:B8,2,FALSE) it gives me the value 12 instead of the summation (12+6+7= 25) is dere any way i can get multiple values using vlokup. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get multiple values in vlookup?
On Sun, 20 Aug 2006 09:30:01 -0700, pvuv
wrote: hello. i am a project planner and doing a quantity analysis whose spreadsheet is huge & simalar to this eg : code quantity a 12 s 3 d 45 total A = 12 a 6 g 67 a 7 d 88 when i tried the vlook up finction =VLOOKUP(A2,A1:B8,2,FALSE) it gives me the value 12 instead of the summation (12+6+7= 25) is dere any way i can get multiple values using vlokup. Not with Vlookup but try =SUMIF(A:A,"A",B:B) Better still, since you may want totals for all the column A values, take a unique list of all column A valuse in say Column C, then in D1 put =SUMIF(A:A,C1,B:B) and copy down. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get multiple values in vlookup?
This may work for you too:
=INDEX($B$1:$B$8,MATCH(1,($A$1:$A$8=A2)*($B$1:$B$8 =B2),0)) Commit with Ctrl + Shift + Enter (not just Enter). Fill down as needed. -- RyGuy "Bob Phillips" wrote: =SUMIF(A1:A8,A2,B1:B8) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "pvuv" wrote in message ... hello. i am a project planner and doing a quantity analysis whose spreadsheet is huge & simalar to this eg : code quantity a 12 s 3 d 45 total A = 12 a 6 g 67 a 7 d 88 when i tried the vlook up finction =VLOOKUP(A2,A1:B8,2,FALSE) it gives me the value 12 instead of the summation (12+6+7= 25) is dere any way i can get multiple values using vlokup. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple VLOOKUP | Excel Worksheet Functions | |||
VLOOKUP - Multiple cells in lookup value | Excel Worksheet Functions | |||
Multiple if or multiple vlookup | Excel Worksheet Functions | |||
VLookup for multiple values!! | Excel Worksheet Functions | |||
VLOOKUP to search multiple values? | Excel Worksheet Functions |