Variable Increasing Number for Formula

[mstark17]

Not sure what to call it but what I'm trying to do is make an auto fill formula that I can drag and fill but the problem is it uses a Table so excel wants to stay in the table when I try to drag it. So currently my formula is =Table1[[#Headers],[Column1]] . And what I want to do is make it to where the number is basically an N function that constantly goes up by 1 if I drag and auto fill cells below it. For example.


Formula: =Table(N)[[#headers], [Column1]]

	A
1	=Table1[[#headers], [Column1]]
2	=Table2[[#headers], [Column1]]
3	=Table3[[#headers], [Column1]]

Is this possible?

[TMS]

Something like:

Please Login or Register  to view this content.

[mstark17]

That does work but all that does is put a text variant of what I'm trying to do. I guess to be more specific I'd like to do a drag and auto fill for hyperlinks to go to a table in my spread sheet. I work with multiple people so we mostly use excel online and I'd like to have a hyperlink that anyone can drag and fill and it'll hyperlink to the new table. so similar to autofilling a row for 1-10. I'd like it to where I can auto fill and it'll link to the tables that are numbered.

Not sure if it's possible at all but worth a shot so I don't have to manually input a ton of them

[TMS]

Thing is, you know what you're looking at and what you're trying to do with it. We, on the other hand, only have the table of text data that you have included in your post and need to guess how we might produce what you have in your mind's eye.

Please see the yellow banner at the top of the page.