Combining VLOOKUP and HLOOKUP ?

Greetings to all forum members!

As I only have very basic excel knowledge hopefuly the pros among the members can help me to accomplish a task.

Included you can see a screenshot of what should be done, basically it is reorganizing the data according to the the column headers (letters) and item numbers (1-5) which are not in alphabetical order.

Data from a matrix (blue) should be put in the appropiate cells to the right. There are a lot of instructions on how to use VLOOKUP or HLOOKUP and combining it with MATCH. Those however did not work out for me.

The data is provided in a matrix organized like shown.

1.jpg

Any input is highly appreciated.

Kind regards,
fannta

Try

=INDEX($C$3:$F$7,MATCH($H3,$B$3:$B$7,0),MATCH(I$2,$C$2:$F$2,0))

@Jonmo1

Works like a charm, it only took 2 minutes for a perfectly working reply, I am amazed.

Thanks again!

You're welcome.