Excel Formula

[lee1767]

Dear All,


I have the following data that I need excel formula or any better method to do the work.


DATA :

Part No. 01/09 10/09 15/09 11/09

A 5 1 1 2

B 10 4 1 2

C 8 9 8 3


Summary Report : Daily


Part No 01/09 02/09 03/09 04/09 05/09

A

B

C


How to capture the data into the daily summary report?


Please help.


Thanks.

 

[Faseeh]

So your data is in A1:E4, and the following table is on anther sheet from A1:J4 like below:

[pre]

Part	1-Sep	2-Sep	3-Sep	4-Sep	5-Sep	6-Sep	7-Sep	8-Sep	9-Sep
A	5				1		1		2
B	10				4		1		2
C	8				9		8		3[/pre]

`

Enter this formula in cell B2 in second sheet and drag to entire cells:


=IFERROR(INDEX(Sheet1!$B2:$E2,,MATCH(B$1,Sheet1!$B$1:$E$1,0)),"")

Note that i have assumed parts to be always in same order.


Regards,

 

[lee1767]

Sorry, my mistake.


The Part No. in data sheet in not the same order as the summary report.

 

[Faseeh]

Hi lee,


Please see this file:


http://dl.dropbox.com/u/60644346/lee1767_Match_Address_Indirect.xlsx


Regards,

 

[Luke M]

Duplicate threads created. Please continue discussion here:

http://chandoo.org/forums/topic/excel-formula-7