a table's name using a formula

[drom]

Hi and thanks in advance!

I am trying to get a formula not vba and/or macro to get a table's name

so If a tables address is A5:Z560 know the name of the table that has this range.

ps: I know how to do this using a macro

it's why I would like to know if is possible to have this information using a formula

 

[PCosta87]

Hi,

I don't think it is possible to get the name with a standard function.
I understand you were looking for a non VBA approach but have you considered a UDF? It still requires VBA to create the custom function but after that it would be used as a regular function on the sheet.

 

[Nikunj Rastogi]

It can not possible to get range name via standard function. it is possible with UDF only.