Solved

Getting hyperlinks in a lookup

Posted on 2016-09-07
2
51 Views
Last Modified: 2016-09-26
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
Comment
Question by:spicecave
2 Comments
 
LVL 32

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 41787775
Try wrapping the VLOOKUP formula into a HYPERLINK formula:

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

Thanks
Rob H
0
 

Author Closing Comment

by:spicecave
ID: 41815837
Thanks Rob for your help
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now