Populating data from one table when target table has the same product names

[markdlevi]

Hi All,

I have to populate a table with information from another table (please see attached spreadsheet – the upper table with the blue heading is the table which has to populate with data from the table below it – in yellow).

In Row 2, when a user selects via a drop down menu which product they want, all the relevant information pulls into the upper table from the lower table. The problem is, Column 1 in the lower table has product names which are the same so I can’t do a vlookup or figure a way how to do this.

Please could you help!

Thanks,
Mark

[Special-K]

Your description is not totally accurate.

"the upper table with the blue heading is the table which has to populate with data from the table below it – in yellow)."

Where does Accumulating Distribution come from? IT doesn't appear in the table below as that name ?

[markdlevi]

Sorry I removed that in the version I uploaded. it can be ignored. thanks

[Special-K]

in E5
=IFERROR(INDEX($D$15:$I$36,MATCH($C5,IF($A$1=$C$15:$C$36,$D$15:$D$36),0),COLUMN()-3),"")
Array formula, use Ctrl-Shift-Enter

copy across and down as far as I11.

Change A1 in the formula above to whatever cell contains the matching Product as you haven't specified that.

NOTE: Array formulas can be slow, the more you have the slower the calculation. You should be ok with these few.

[markdlevi]

Thanks for your help!