Hello,
Is there a way to retrieve range name if value is in the range?
For example I got this column wit names:
name 1
name 2
name 3
name 4
name 5
name 6
name 7
name 8
name 9
name 10
name 11
name 12
This column has name ranges:
1st range called €œCA€� has these names:
name 1
name 2
name 3
name 4
2nd range called €œDC€� has these names:
name 5
name 6
name 7
name 8
name 9
And the 3rd range is called €œWA€�:
name 10
name 11
name 12
Lets say in different worksheet my formula returned €œname1, name8 and name
11€�, in the same worksheet I would like to return the location or range name
associated with name.
Desired result:
__A_______B__
name 1___CA__
name 8___DC__
name 11__WA__
I think with nested IF functions I could achieve desired result; problem is
I am exceeding the limit of allowed nested functions. And I also dont want
to add additional column in original data sheet were I specify the
location/range name for each name.
Any suggestions?
Thank you,
Guntars