Excel 2010 - INDEX formula issues

[sldonovan77]

Hi all,
I'm new to this and I'm having a lot of problems trying to work out if I'm using the right formula. I'm trying to use the index formula but with no success. I'm trying to gather certain data using a "Supplier ID". If I change the Supplier ID I would like the table to reflect the changing values in the Results Table.
I have attached the spreadsheet and data. If anyone can give me an idea of what to do that would be greatly appreciated. If possible, 1 formula for 1 column of data would be greatly appreciated. Then I can work out how to do the others.

Your help would be greatly appreciated!!
Regards,
Sarah

[:) Sixthsense :)]

In B6 Cell of Results Sheet - ARRAY FORMULA - REQUIRES CTRL+SHIFT+ENTER

=IFERROR(INDEX('Data Sheet'!$A$2:$R$15,SMALL(IF('Data Sheet'!$A$2:$A$15=$C$2,ROW('Data Sheet'!$A$2:$A$15)-ROW('Data Sheet'!$A$2)+1),ROW($A1)),MATCH(B$5,'Data Sheet'!$A$1:$R$1,0)),"")

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.

[sldonovan77]

Hi Sixth Sense,
Thank you so much for your prompt assistance.
I will give it a try and let you know

Many thanks,
Sarah

[sldonovan77]

In B6 Cell of Results Sheet - ARRAY FORMULA - REQUIRES CTRL+SHIFT+ENTER

=IFERROR(INDEX('Data Sheet'!$A$2:$R$15,SMALL(IF('Data Sheet'!$A$2:$A$15=$C$2,ROW('Data Sheet'!$A$2:$A$15)-ROW('Data Sheet'!$A$2)+1),ROW($A1)),MATCH(B$5,'Data Sheet'!$A$1:$R$1,0)),"")

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.

Hi Sixthsense,
I tried what you suggested and the first line was correct but then no other information appeared when I dragged the formula down and to the right. Also when I changed the Supplier ID to "19", the data associated was incorrect.
Can you have a look at the spreadsheet attached
Regards,
Sarah

[:) Sixthsense :)]

You have entered the formula as normal with enter...

But it is an ARRAY FORMULA which requires CTRL+SHIFT+ENTER. Please pay some attention for the text we quote... Even I highlighted some text with colors....

[sldonovan77]

OK I will try again

[sldonovan77]

Fantastic!!! It worked!!
Thank you very much for your help. I've been at it for days

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback

[sldonovan77]

Oh, how do I mark this as "solved"?

[sldonovan77]

It's ok! I've done it