Excel

Iraj · #1 10-26-2013, 01:34 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Excel 2007] Building Power Point Slides from data in an Excel Table	bremen22	Excel Programming	1	08-07-2013 11:01 AM
Paste special an Excel range into Outlook as an Excel Worksheet	charlesh3	Excel Programming	3	02-04-2013 04:33 PM
Excel 2011 can't open old Excel 98 or Excel X files	FLJohnson	Excel	8	05-09-2012 11:26 PM
Excel 2007 custom ribbon not showing in Excel 2010	Paulzak	Excel	2	02-17-2012 06:35 PM
saving data in excel 2010 from excel 2003	johnkcalg	Excel	1	02-06-2012 07:33 PM