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