Vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

creating formula to adjust per month 2
Formula help 1
Vlookup dependent on a validation table 6
Coloured Cells 8
Average cells based on column header 6
Vlookup error? 6
Excel Vlookup Help 0
problem with formulas (2) 7

Back
Top