Sorry! Defined Tables are available starting from Excel 2007!
A possible workaround for older versions:
Add to table a column where the row number of table's datarange is calculated, like
=ROW() - HeaderRowNumber
(In case the start row if datarange is always fixed, you can skip this part, and simply calculate the datarange row number whenever it is needed);
Define dataranges of table columns you need to refer to in your formulas as dynamic names. Like the datarange where row numbers mentioned above are calculated. P.e. the row numbers are calculated in column F, and the header row of table is 1, then the formula for named range nRow will be something like
Code:
=OFFSET($F$1,1,,MAX($F:$F),1)
;
To get a value from cell in current row of datarange defined e.g. as nTest in same table, use formula (e.g. in row 2 of your worksheet) like