| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
vlookup for a value appearing more than once
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 -- rITA |
|
#2
|
|||
|
|||
|
You need to use SUMIF. For an example, see:
http://www.techonthenet.com/excel/formulas/sumif.htm HTH Jason Atlanta, GA -----Original Message----- 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 -- rITA . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
| VLOOKUP help | Excel Worksheet Functions | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
| VLOOKUP not working | Excel Worksheet Functions | |||
Hybrid Mode
