Return value in last column of row in table

[nmbell]

Good morning. I am trying to find out if there is a formula to always return number in the last column of a row in a table. I am trying to pull information from TabA into another data set in TabB. The issue is that the table in TabA is currently only 100 columns wide but will continue to get wider. I want the information in TabB to always come from the last column in each row of TabA regardless of the changing columns. Is there a formula that will do this so we don't have to continually update the reference in TabB as the table in TabA grows? For example the first reference in my data on TaB says ='TabA'!DR8. When TabA has grown, and the last column is now say FR8, is there a formula to automatically now pull that? If it helps, the data in TabA is a table named Variance.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also what is the name of the table in TabA?

 

[nmbell]

Thank you. I have updated my account details. I am using WIndows and on 365. My table name on TabA is Variance

 

[Fluff]

Ok, how about

=INDEX(TAKE(Variance,,-1),ROWS(A$2:A2))