Copy/Drag from sequential column to non sequential ones while retaining sequention

=INDEX(Sheet2!B:B,(ROW(A1)-1)*10+2)

Drag it down...

Originally Posted by :) Sixthsense :)

=INDEX(Sheet2!B:B,(ROW(A1)-1)*10+2)

Drag it down...

First thanks, but obviously I didn't explain it good.
Basically I need the reverse of yours. At least how I have set it your works like this. When I put the formula it brings me back the 2nd name in the list, (instead of the 1st, I changed the 2 in the end with a 1 and now it bring me me back the 1st name) When I drag it down 1 cell it gives me the the name 10 rows down. What I need is to skip 10 cells and copy the formula 10 down and give me the 2nd name, then another 10 down and 3rd name and so on...
I will try to play around with your formula a bit more maybe be able to reverse it.

edit: I tried with simple =ROW(A1) in cell one and it gives me the name from B1, then I copy it 10 cells down on row 11 to make it work I need it to be like this =ROW(A11)-9, then I copy it to row 21 and to bring me back the name from B3 it need to be =ROW(A21)-18 etc etc
this when I am working on the same sheet.

edit2: I know I can go around it with VLOOKUP if if I add a unique number to each of the "name" rows and and a add that number in the form that I need printed , but I would really like to avoid crowding the tables more.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic