excel - How do I keep the hyperlinking of my search results? -

i've got long list of names , categories in excel , each item in list hyperlinks worksheet in book. because it's unwieldy ctrl+f elements in list since it's massive, i've set search box using =search, =rank, , =vlookup functions. search box work search draws in , displays text , these search results not retain original hyperlinking , defeats point of database.

long story short: how can keep hyperlinking of search results yielded search function constructed in excel 2007?

thanks, grateful responses. let me know if can clarify doing. p.s. have more primitively limited knowledge of vba if vba way go, i'd happy learn.

if can find item searching for, can link them cell has link (inception style)

e.g. in new workbook:

then, can link cell has letter a with:

=hyperlink("[book1]sheet1!"&address(match("a",a1:a3,0),1),"go search term") 

this search a in a1:a3 area of spreadsheet, make address using match position, , column 1, add initial part of reference, , create hyperlink text "go search term" linking text

the hyperlink created using formula must have workbook , sheet name (so can't link a1, has [myworkbook.xlsx]mysheet!a1