Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing vlookup cells
I have a sheet with 5 colums that has a finance number and 3 cols that have
numbers. I gave it a range res. On my main page I have it do a vlookup of the finance number =vlookup(b2,res,3,false). Now the problem is that we have offices that have multiple zip codes with the same finance number. What I want to do is when the vlookup looks up the finance number, it adds all the numbers that go with that finance number. For example if a2 and a5 have the same finance number in the res range then it would add c2 and c5 in the cell I put the vlookup in. Can this be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Vlookup and Cells with Formulas | Excel Discussion (Misc queries) | |||
summing cells with text and numbers | Excel Worksheet Functions | |||
vlookup cannot get data for some cells | Excel Worksheet Functions | |||
VLOOKUP - Multiple cells in lookup value | Excel Worksheet Functions |