I want a function to select every 2nd column on a particular row and display it in another sheet.
I have two sheets: Sheet1 and Sheet2
In Sheet1 A2 I have a list of numbers that start from 1 to 1000.
In Sheet1 A3 I have links that I want to select/display in Sheet2.
I want to choose what link to display in Sheet2 A2 by writing a function in Sheet2 A1 so that when I write "1" I get the link on the same row as page 1.
See example: Image (GIF)
And I want to do this without using macros if possible.
Someone suggested a function like this:
I played with the numbers a bit but if this could be changed to help with my problem it would be great.