Getting hyperlinks in a lookup

Jase Alexander
Jase Alexander used Ask the Experts™
on
Hi Guys

Hope you can help

I previously had some excellent assistance with this however, I have adapted and upgraded the attached sheet (after much deliberation) and now it is ready to use, I am encountering some problems in getting the hyperlinks through a lookup.

When I create a hyperlink in column X against the supplier reference and use the lookup formula in cell I2 to grab the hyperlink, it is now not allowing me to click the hyperlinked 'folder' - instead it is just displaying the formula ??

When I hover over the link it appears to want to work and it was working before and now I do not know why it is not happening ??

Am I not formatting something correctly?

Any suggestions would be most welcome

J
FinesV1.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Finance Analyst
Commented:
Try wrapping the VLOOKUP formula into a HYPERLINK formula:

=HYPERLINK(VLOOKUP(G2,C6:X16,22,FALSE))

Thanks
Rob H
Jase AlexanderCompliance Manager

Author

Commented:
Thanks Rob for your help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial