display the name of a named range in a cell of the range itself

[ymmotteov]

Hi all,

Short question.

Is there a way to display the name of a named range in a cell of that named range?

[tim201110]

there is

Please Login or Register  to view this content.

[ymmotteov]

Thanks for the quick response!

[shahab47]

Hello there..

I have a slighty different question but related to similar topic.
I want to display the name of the namerange to which a cell belong to.

For example, cells A1/A2/A3 are called namedrange "my_table". A1/A2/A3 are populated with lion/tiger/hippo.
now in cell F1, if I populate lion, I would like to dispaly its namedrange's name ie my_table in cell F2.
Is this doable?
Based on solution in the spreadsheet in this thread, it looks like it is, but not sure how...

Thanks
Shahab

[6StringJazzer]

I have a slighty different question

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread