Headers for defined Tables can't be numbers (or formulas).



And for your case, your solution is too complex!

Attached Files

SalarySchedNew.xlsx (35.9 KB, 10 views)

[And for your case, your solution is too complex![/QUOTE]
Arvil may I ask about the function of the extra comma after tAnnex?

I assume the question is about formula in SALARY column of Table tAnnex.

tAnnex in formula returns datarange of Table tAnnex, i.e. a range A2 : D5 in example file. NB! This range is 2-dimensional, i.e. in general it contains rows and columns.
For 2-dimensional ranges/array:
INDEX(DataRange,RowNo,ColumnNo), returns a value from single cell;
INDEX(RowNo,), returns a single row from datarange;
INDEX(,RowNo), returns a single column from datarange;

As follows, 'INDEX(tAnnex,,[@[SALARY STEP]]+1)' returns a datarange column ([@[SALARY STEP]]+1 from tAnnex, i.e. when SALARY STEP in tSalaries is 1, the column Step1 of tAnnex is returned, when SALARY STEP is 2, the column Step2 is returned, etc.

But why are there two commas in the formula?
=INDEX(tAnnex,,
I tried deleting one comma but got error result.