Excel Structured Reference - Retrieving current row with @ or #This Row is not working

Question

I am on office 0365 enterprise version - Microsoft® Excel® for Microsoft 365 MSO (16.0.14228.20292) 32-bit. I am working on a table and would like to use structured referencing to dynamically retrieve the current selected row. I have gone through video tutorial where the syntax of using TableName[@columnname] works. Unfortunately when I attempt on my end either with @ or "#This Row" it show VALUE error as shown on screenshot below. Any ideas?

Answer 1

@Year refers to the current row of the Year column. For example, assuming that the value 1999 is in cell B3, putting the formula =Table1[@Year] in cell D3 will return the value 1999. But you've put the formula in what looks like cell B14. The table doesn't extend to row 14, so there is no value to return - hence the #VALUE! error.