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?