Home

Hyperlink Availability Question

Highlighted
Shawn French
Occasional Contributor

I have the following formula in cell N11:

 

=IFNA(HYPERLINK("#'" & I11 & "'!A" & MATCH(K11,INDIRECT("'" & I11 & "'!A:A"),0),"VID"), "")

 

which will refer cell I11 and take me to that cell located in a different sheet (see second picture).

Screen Shot 2019-01-03 at 7.29.32 AM.png

Screen Shot 2019-01-03 at 7.27.18 AM.png

Some of these cells in the second picture will be hyperlinked to a video, and some will not.

 

Is there a way I can create the initial formula in cell N11 to disappear if the reference located on the second picture is NOT hyperlinked? This may seem like a very particular question, but is important to how this template will function.

 

Thank you all for your consideration.