SOLVED

Lookup data from sheet, link to that data on click

Copper 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
best response confirmed by seamon1 (Copper Contributor)
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.
1 best response

Accepted Solutions
best response confirmed by seamon1 (Copper Contributor)
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))

View solution in original post