how to get index of defined name in excel

[ramgokul]

I defined a name in excel like this "'Test!$K$5:$K$504" as Student Name.
So the defined Range will have list of studentName in it .
If i'm selecting a studentName how to get the index value defined for the coresponding Student.


Thanks in advance
Ram
--------------------------------------
Cool

 

[Aladin Akyurek]

I defined a name in excel like this "'Test!$K$5:$K$504" as Student Name.
So the defined Range will have list of studentName in it .
If i'm selecting a studentName how to get the index value defined for the coresponding Student.


Thanks in advance
Ram
--------------------------------------
Cool

=MATCH(A2,StudentName,0)

would determine the position (index) of the student in A2 in the range StdentName stands for.

 

[ramgokul]

thanks Aladin

 

[Aladin Akyurek]

thanks Aladin

You are welcome. Thanks for providing feedback.