|
|
#1
10-26-2013, 01:34 AM
|
|||
|
|||
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. 
|
|
|
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 |
Windows 7 64bit 
Office 2007
Threaded Mode