I am not sure I understand your request. Can you give an example of what your input and expected results are?



If you use a simple Match() function, it finds the name in the hyperlink result... e.g

=MATCH(B3,A1:A3,0) returns 3 which is correct.