MrExcel MVP, Moderator
- Jun 12, 2014
- Office Version
As it's now a structured table you can use this formula
No need to rename the sheet, although you can if you want, and rather than downloading the data from time to time, just goto the "Table design" tab (the cursor must be somewhere in the table for it to appear) & then click "Refresh" and everything should update itself, including the formula.
=INDEX(Indexation_amounts_in[:],MATCH("Old age security repayment threshold",Indexation_amounts_in[Description],0),MATCH(YEAR(TODAY())&"",Indexation_amounts_in[[#Headers],:],0))