Can I use a dynamic reference in a table name?

[AaronDP]

Hi

Does anyone know how to use dynamic reference as part of a table name. So If I have 10 tables called...

Revenue_WK1
Revenue_WK2
...
Revenue_WK10

Can I then select the relevant Table using =SUMIF(Rev_WK10[ITEM],"11*",Alacer!D:D) where the _WK10 part of the table name is dynamically references.

I have tried =SUMIF((CONCATENATE("rev_"&E2))[ITEM],"11*",Alacer!F:F)

but...

All help gratefuly recieved.

Thanks

Aaron

 

[Derek Brown]

This is a DUPLICATED post of:
http://www.mrexcel.com/forum/excel-questions/694645-usind-dynamic-references-table-name.html