Forum Discussion

seamon1's avatar
seamon1
Copper Contributor
Mar 28, 2019

Lookup data from sheet, link to that data on click

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!

link
  • Twifoo's avatar
    Twifoo
    Mar 28, 2019
    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))
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 28, 2019
    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))

Resources