Advanced Conditional Hyperlink Help!

[Shawn French]

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!

[#2]

Change your formula to:

=HYPERLINK(CONCATENATE("#'", D11, "'!A1"), "VID")

[#3]

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!

[#4]

Perhaps

=HYPERLINK("#'" & D11 & "'!A" & MATCH(F11,INDIRECT("'" & D11 & "'!A:A"),0),"VID")

[#5]

IT WORKED! First, I am very surprised I typed it correctly on the first try. Second, this is awesome! Thank you!

[#6]

You are welcome