Index/Match Formula question

[gkisystems]

I'm using an index match formula where the index is a named table called "UnemploymentTable" on another worksheet within my Excel workbook (see screen shots below). The trouble I'm having is when I drag my formula to the right, the index/match formula is going to my table and looking up one column to the right for every time I drag the formula right. I would normally solve this problem by adding dollar signs $ to my formula to lock the formula in place, but because it's going to named table with named fields in that table, I'm unable to add the dollar signs. Anybody know how to get around this? I want to keep the named ranges so the formula lookups continue to work as I add to the table over time (opposed to looking up specific cells).

=INDEX(UnemploymentTable[#All],MATCH(C$4,UnemploymentTable[[#All],[Year]],0),MATCH("Annual",UnemploymentTable[#Headers],0))/100

 

[Caribeiro77]

This might help you....

https://www.youtube.com/watch?v=gZstykyq3Ns

 

[dourpil]

As probably say in the video, to make table reference absolute (vs relative), use for example

Mytable[[This column]:[This column]] instead of
MyTable[ThisColumn]

 

[gkisystems]

As probably say in the video, to make table reference absolute (vs relative), use for example

Mytable[[This column]:[This column]] instead of
MyTable[ThisColumn]

Perfect! Thanks guys!