Hyperlink formula to cell with data

[Brownick]

Hello all,

I am currently trying to use a hyperlink formula, along with index & match, to be able to click a cell and follow the same hyperlink from a cell in a back tab. The front tab is called Template, back tab is titled Photo Tracking.

My current equation is =HYPERLINK(INDEX('Photo Tracking'!C:C,MATCH("*"&'Template'B13&"*",'PHOTO Tracking'!K:K,0)),"OK")))

When I hyperlink a cell on Photo Tracking and leave the name of the file, this equation works fine; however, when I input a value (1-4) over the hyperlinked cell the formula stops working and I get the message "Cannot open the specified file"

The hyperlink still works on the Picture Tracking tab, but does not on the front tab.

I'm not really sure what the issue is, so any help you can provide would be greatly appreciated.

 

[Brownick]

Jerry,

Thank you for all of the assistance, this worker perfectly.

Best wishes.

 

[Brownick]

Jerry,

What you have provided works perfectly. Thanks for your time & effort.

 

[Jerry Sullivan]

You're most welcome. I learned some new things in the process!