Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Course Of The Month
8 days, 6 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Getting hyperlinks in a lookup
Posted on 2016-09-07
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Suggested Courses
Course of the Month8 days, 6 hours left to enroll
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.