Forum Discussion

Shawn French's avatar
Shawn French
Copper Contributor
Jan 03, 2019

Hyperlink Availability Question

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).

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.

No RepliesBe the first to reply

Resources