I need to make a table of specific cell information from my data.
Would Vlookup work to get information from cells that are 54 cells apart?

i.e...I need the amount in cell A5 in cell J5 and in J6 I need the
information from cell A59. etc.....
I hope I explained this ok...lol.

Thanks for your help

If I understand you correctly, you can use this formula:

A5: =INDEX(A:A,(ROW()-5)*54+5)


In article ,
frustratedwthis wrote:

I need to make a table of specific cell information from my data.
Would Vlookup work to get information from cells that are 54 cells apart?

i.e...I need the amount in cell A5 in cell J5 and in J6 I need the
information from cell A59. etc.....
I hope I explained this ok...lol.

Thanks for your help