• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Link a Data Table Name with a Range

Hi guys!

I have a doubt regarding Excel Data Tables.

I was wondering if it's possible to refer to it using a range. For example:

The formula is:


I want to make the "abcp11" part variable, using the name "abcp11" in the range B5:


The objective is that when I need to recall lots of data tables using this formula above, I lost a lot of time changing the name of various data tables. If I have ranges with the name of the data tables I could do this in no time!

I'm attaching the file if you want to take a deeper look at it:


Thanks for the attention!

Henrique Carvalho


Excel Ninja
Staff member

You will have to use the Indirect function to help out here