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?
|