Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP FOR MULTIPLE VALUES
In a spreadsheet, I have a value which appears more than once in different
rows in a table array. I need to do a vlookup which checks the value in this table array and sums up the amounts in an adjacent column applicable for this value. Can I achieve this? -- rITA |
#2
|
|||
|
|||
It sounds like you could use =sumif().
Debra Dalgleish has lots of info on counting and summing at: http://www.contextures.com/xlFunctions01.html and http://www.contextures.com/xlFunctions04.html RITA wrote: In a spreadsheet, I have a value which appears more than once in different rows in a table array. I need to do a vlookup which checks the value in this table array and sums up the amounts in an adjacent column applicable for this value. Can I achieve this? -- rITA -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get mutiple values using vlookup in excel, lookup value . | Excel Discussion (Misc queries) | |||
vlookup to see 2 values? | Excel Worksheet Functions | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |