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