Hyperlink Availability Question

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.