Hi there,
In cell DG8 I have the following formula
="vs "&AG1&" "&TEXT(AG3,"dd/mm/yy")
This works fine. In cell DI8 (two cells along) I would like to create a formula which does the same thing as above but instead of using AG1 it obtains its data from cell AY1 (18 cells along).
I would then like to repeat this formula another 2 cells along, and then again and so on. without doing it manually is there a formula that is able to read 2 cells back and then add 18 cells along to where that cell gets its data from?
Any suggestions?
Bookmarks