help with hyperlinks

M

Michael

Hello all,

I need a way to make a hyperlink to a cell in another worksheet where i
don't know the cell reference. I'll explain it more clearly...

At the moment i have =VLOOKUP(C6,Brother!A18:C25,2) which returns a text
string. After this i want to be able to click on the cell (where the text
string is displayed) and for it to 'jump' to the cell where it got this
information.

So far i can find heaps of functions that will search for the information in
a cell but i can't find one that will give me an output of the cell
reference. I'm sure there must be one that i have over looked.

Thanks

p.s was told to try: =HYPERLINK("#'Brother'!B" &
MATCH(C6,Brother!A18:A25),VLOOKUP(C6,Brother!A18:C25,2))
But this didn't work becuase it stoped returning a search result.
 

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 hell 3
VLOOKUP with a Named Range argument 1
Finding the height of a row in a word table from Excel 0
Copy hyperlinks 6
Problem with hyperlink macro 0
Dynamic Hyperlinks - Changing Folders and Filename 0
VLOOKUP referencing a cell with a URL 1
IF(ISNUMBER question 0

Top