SOLVED
Home

Lookup data from sheet, link to that data on click

%3CLINGO-SUB%20id%3D%22lingo-sub-389809%22%20slang%3D%22en-US%22%3ELookup%20data%20from%20sheet%2C%20link%20to%20that%20data%20on%20click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389809%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIf%20I%20lookup%20one%20data%20from%20one%20sheet%20using%20vlookup%2C%20is%20there%20a%20hyperlink%20or%20other%20method%20that%20when%20I%20click%20this%20data%20that%20they%20found%2C%20it%20go%20straight%20to%20that%20page%20that%20cell%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EFor%20example%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%3DVLOOKUP(A2%2CSheet2!G%3AN%2C5%2CFALSE)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20click%20on%20this%20cell%20and%20go%20straight%20to%20sheet%202%2C%20the%20cell%20that%20this%20forumla%20found.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-389809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Elink%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389868%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20data%20from%20sheet%2C%20link%20to%20that%20data%20on%20click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389868%22%20slang%3D%22en-US%22%3EYou're%20welcome.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389858%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20data%20from%20sheet%2C%20link%20to%20that%20data%20on%20click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389858%22%20slang%3D%22en-US%22%3EThanks%20a%20lot%2C%20this%20works%20fine%20now!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389826%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20data%20from%20sheet%2C%20link%20to%20that%20data%20on%20click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389826%22%20slang%3D%22en-US%22%3EIf%20clicked%2C%20this%20formula%20will%20allow%20you%20to%20jump%20to%20the%20location%20of%20the%20lookup%20result%3A%3CBR%20%2F%3E%3DHYPERLINK(%22%23Sheet2!K%22%26amp%3B%3CBR%20%2F%3EMATCH(A2%2CSheet2!G%3AG%2C0)%2C%3CBR%20%2F%3EVLOOKUP(A2%2CSheet2!G%3AN%2C5%2C0))%3C%2FLINGO-BODY%3E
Highlighted
seamon1
New Contributor

If I lookup one data from one sheet using vlookup, is there a hyperlink or other method that when I click this data that they found, it go straight to that page that cell?
For example:
=VLOOKUP(A2,Sheet2!G:N,5,FALSE)
I click on this cell and go straight to sheet 2, the cell that this forumla found.

Thanks!

3 Replies
Solution
If clicked, this formula will allow you to jump to the location of the lookup result:
=HYPERLINK("#Sheet2!K"&
MATCH(A2,Sheet2!G:G,0),
VLOOKUP(A2,Sheet2!G:N,5,0))
Thanks a lot, this works fine now!
You're welcome.