CODEWITHSUNDEEP
excelexcel-formula
Michael Cortez
Michael Cortez

Reputation: 1

Want to hyperlink to a certain cell

I am trying to build a dynamic hyperlink. My data validation has numbers 1 - 222. The row is 8, this does not change.

When the user selects 57 from the drop down I want a link that takes them to Row 8 Column 57.

Any ideas on how to build this?

Upvotes: 0

Views: 52

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

where your drop down is in B1:

=HYPERLINK(MID(CELL("filename",A1),FIND("[",CELL("filename",A1)),999)&"!"&ADDRESS(8,B1,1,1),"goto")

Upvotes: 1

Related Questions