Excel
Hi,
I have A2:A20 different names repeated also, D2:20 used material repeated names in different date related to the names in column A2:A20, and prices for those materials in H2:H20. Now want a formula in sheet 2 cell A2 as summary sheet, to look at Column A sheet1, to find same name in different cells, and cell B2 in sheet 2, to find the used material by that name in Column D, and cell C2 in sheet 2, to sum the related prices in column H for that material.
Can you help please?
Cheers, Iraj.
Last edited by Iraj; 10-26-2013 at 06:13 PM.
|