Thread: vlookup totals?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lazclark
 
Posts: n/a
Default vlookup totals?

I have two spreadsheets - In one column on this 1st sheet, there is a product
code. On another spreadsheet, one of the columns uses the corresponding
product code on more than one occasion in the column.

I need the second column of the first sheet to calculate the totals
corresponding to the product codes in the second sheet.....

So, rather than just return one value, i need vlookup to total all of them
where the product code matches - is this possible?