Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 74
  • Last Modified:

Getting hyperlinks in a lookup

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
0
Jase Alexander
Asked:
Jase Alexander
1 Solution
 
Rob HensonFinance AnalystCommented:
Try wrapping the VLOOKUP formula into a HYPERLINK formula:

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

Thanks
Rob H
0
 
Jase AlexanderCompliance ManagerAuthor Commented:
Thanks Rob for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now