Forum Discussion
Solved
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,...
- 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))
