How to match & transpose?

[vegobu]

Hi guys, I am new here. I am trying to look up & transpose multiple columns to row. A file is attached herewith for the gurus to explore.

Really appreciate your assistance.
colorant tests.xlsx

Vegobu

[Marcol]

Your profile states you are using 2003 but your sample workbook is 2007 or later.

Try this in B14

=IF(ISERROR(INDEX($A$5:$I$10,MATCH($A14,$A$5:$A$10,0),MATCH(B$13,$A5:$I5,0)+1)),"",INDEX($A$5:$I$10,MATCH($A14,$A$5:$A$10,0),MATCH(B$13,$A5:$I5,0)+1))

Drag Across to Column I, then down as required.

For 2007 and later you could use

=IFERROR(INDEX($A$5:$I$10,MATCH($A14,$A$5:$A$10,0),MATCH(B$13,$A5:$I5,0)+1),"")

Hope this helps.

[vegobu]

thank you, Marcol
u r good