View Single Post
 
Old 01-15-2018, 06:03 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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.
Reply With Quote