Need formula to pull data from one sheet to another

[darkfeld]

First of all...I have Excel 2003

My spreadsheet has multiple lines of data for multiple items (have a specific item #) and I need to be able to enter an item # on a different sheet so that the requested information can be pulled from the data source. The items have information on multiple rows. I need to have all of the rows pulled into my output file when I specify the specific item. #.

I have attached a spreadsheet showing the type of data is contained and what my desired output would look like.

Thank you for your help in advance!

darkfeld

[:) Sixthsense :)]

In A6 Cell - Array Formula - Requires CTRL+SHIFT+ENTER

=IFERROR(INDEX(INDEX('Data Source'!$A$2:$G$6,,MATCH(A$5,'Data Source'!$A$1:$G$1,0)),SMALL(IF('Data Source'!$A$2:$A$6=$A$1,ROW('Data Source'!$A$2:$A$6)-MIN(ROW('Data Source'!$A$2:$A$6))+1),ROW(1:1))),"")

Drag it down and right...

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.