Hyperlink and lookup functions

F

Frankyp22

I have 2 sheets in a workbook.
Both Sheets have 1 thing in common:
CustID.

I'd like to put a hyperlink on Sheet 1 when their CustIDs equal each
other.

Let's say you have this:
Sheet 1

CustID
4652
4900
5023

Sheet 2

CustID
4900
5023

So, On Sheet 1, there would be a hyperlink on 4900 and 5023, and when
you click on it, it would take you to Sheet 2, 4900 and 5023
respectively.

I've used lookup functions, hyperlink, if statements... none seem to
work.
Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink and Filter Data in Multiple Sheets 0
Sorting and Filter in Multiple Sheets using Hyperlinks 2
Lookup Function help 1
Hyperlink problems 1
Fixing some bugs 9
Copy hyperlinks 6
If or VLookup function 0
VBA for Dependents shortcut menu 0

Top