Reference to "This Table"

[IronCladRooster]

I am working with about twenty tables and am trying to copy an index / match formula from one to the other. Is there any way to reference a particular header from the table that the formula is located in? The way I have it set up now is the formula matches against [a specific table'sname],[#headername]. However that means for each table I have to go in and change the table's name in the formula.

Here is the full formula I'm currently using

=INDEX(Array,ROW(By_Fund!G1),MATCH(UOBI[[#Headers],[UOB I]],FundSize[#Headers],0))

With the red text being what I want to vary based on the table that the formula is located in.

Thanks!

[hoyasaxa215]

Should be able to achieve this using the "=INDIRECT" function.

http://office.microsoft.com/en-us/ex...in=HP010342656