基于下拉值的超链接到特定的行或单元格
我希望每个人都度过一个愉快的星期五。
我正在尝试创建一个动态的超链接，该超链接将（G2）中的搜索名称作为输入，并让我跳到搜索名称所在的特定行（在此示例中，超链接应跳到单元格B8）。
根据一些互联网搜索，我发现可以在Excel中应用的类似内容，但我认为它在Google表上不起作用。请在下面找到我在（i2）中应用的功能，
=hyperlink("#"&Cell("address",index(Sheet1!B5:B9,MATCH(G2,Sheet!B5:B9,0))),"Click here to move to row")
但不幸的是它不起作用，甚至没有显示为超链接（蓝色带下划线的文本）。你们可以帮助我更多地了解我做错了什么，并且在那里是完成此任务的更好方法。
让我举一个例子，让我说我从G2中的下拉列表中挑选了nishant， 我希望当我单击i2时，链接将使我在此示例中跳到B9。
谢谢您的帮助。
感谢它。
I hope everyone is having a great Friday.
I am trying to create a dynamic hyperlink which takes the searched name in (G2) as an input and allow me to jump to that specific row where the searched name is located (in this example the hyperlink should jump to cell B8).
Based on some internet search i found something similar which can be applied in excel but i don't think it's working on google sheets. Please find below the function that i applied in (I2)
=hyperlink("#"&Cell("address",index(Sheet1!B5:B9,MATCH(G2,Sheet!B5:B9,0))),"Click here to move to row")
Unfortunately it isn't working, and it isn't even shown as a hyperlink (blue underlined text).Can you guys help me understand more what i did wrong, and if there is a better way to do this task.
Let me give another example, Lets say i picked Nishant from the dropdown list in G2,
I want that when i click on I2 the link would make me jump to B9 in this example.
Thank you for your help.
Appreciate it.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试
用网格ID替换1860191576
Try
replace 1860191576 by your grid id