Hi, I'm not very good at this and am having real trouble. Been messing around with some Find functions & googling for help. My problem is very simple I believe (but this is not my forte!)

I have attached an example sheet to illustrate what I mean.

CODE HELP.xlsx

Basically all I want to do is use cell B2 as a reference, to lookup the matching column to that ref in the array D:R. Then copy A2:A20 and paste in the second row of the appropriate column.

:d

TIA for any help!