Hi Guys,
Below function:
HYPERLINK(HLOOKUP($A187,'FID Shelf'!$G$7:$AE$27,M$1,0)
this function receives value 'various', inside 'various' in another sheet I have hyperlink to the website, but function doesn't recognize hyperlink, I receives meesage "Cannot open specified file'.
when change 'various' into address websiste, function works, but for dashboard purpose I need hide website into 'various' Hyperlink.
Any ideas?
Below function:
Code:
Code:
when change 'various' into address websiste, function works, but for dashboard purpose I need hide website into 'various' Hyperlink.
Any ideas?