Forum Discussion
Advanced Conditional Hyperlink Help!
In the above format, I need the hyperlink in cell H11 to reference cell F11 and locate it in sheet 'LowerPush' as seen below. I currently have created the hyperlink so it references cell A1 in the 'LowerPush' sheet, but I want to go to whatever text is in cell F11 in the original sheet, as it is a data validation list sourced from LowerPush. Here is my current formula:
=HYPERLINK(CONCATENATE("#", D11, "!A1"), "VID")
Any help is greatly appreciated!
Change your formula to:
=HYPERLINK(CONCATENATE("#'", D11, "'!A1"), "VID")Hi Jan- Thank you for the response.
When I make the above change adding the apostrophe's, it still refers to !A1, not the cell containing the text from F in the original sheet.
Do you have another idea? Thank you!
Perhaps
=HYPERLINK("#'" & D11 & "'!A" & MATCH(F11,INDIRECT("'" & D11 & "'!A:A"),0),"VID")
