Application.Index & Match nested within a loop

Hi all,

I'm trying to adapt a macro. I have a basic index/ match lookup from one worksheet to another. It returns the value by each column. Example below:

Please Login or Register  to view this content.

What I'm trying to do is put this within a loop. As the loop counts through the columns, the column index will change. I was trying different variations like this but I'm missing something:

Please Login or Register  to view this content.

If there's an answer, I'm sure it's easy and I'm missing something.

Any help gladly appreciated.