hyperlink and cell contents

  • Thread starter Thread starter newbie
  • Start date Start date
N

newbie

Hi,

I'm having a little trouble linking a hyperlink to the contents of a cell. The
hyperlinks seem to be attached to the cell and not the data in the cell, which
is no good seeing I have to sort my data for different circumstances.
Is there some way of making the hyperlink 'follow' the data?

Thanks,
Andrew
 
Maybe you could use the =hyperlink() formula.


Hi,

I'm having a little trouble linking a hyperlink to the contents of a cell. The
hyperlinks seem to be attached to the cell and not the data in the cell, which
is no good seeing I have to sort my data for different circumstances.
Is there some way of making the hyperlink 'follow' the data?

Thanks,
Andrew
Click to expand...
 
A similar question was posted at least a week ago, I tested
with the builtin hyperlinks and had no trouble sorting and
the links went along with he cell content when sorted, and
this was reported by one of the responders then.

Can you provide more information exactly what you have
what you selected before sorting, and how you sorted.
The sort will expand the sort area if you select a single cell.
In general it is best to select all cells before sorting which
you can do with Ctrl+A which has the advantage of not
changing your active cell.
 
Well, hyperlink() did the trick for sorting, but I am having another problem.

I have a large sheet with one column that looks like this:

=VLOOKUP(F3,'Item # & Description'!B$2:C$80,2,FALSE)

The table_array (!B$2:C$80') that it refers to actually has hyperlinks like
this:

=HYPERLINK("C:\...Fittings Spreadsheet\KMB1020R.jpg","KMB1020R")

How do I link the hyperlink to the vlookup function?

Thanks
Andrew



A similar question was posted at leasta week ago, I tested
with the builtin hyperlinks and had no trouble sorting and
the links went along with he cell content when sorted, and
this was reported by one of the responders then.

Can you provide more information exactly what you have
what you selected before sorting, and how you sorted.
The sort will expand the sort area if you select a single cell.
In general it is best to select all cells before sorting which
you can do with Ctrl+A which has the advantage of not
changing your active cell.
</a>
Click to expand...
 
How about just using =hyperlink() once again:

=hyperlink(vlookup(F3,'Item # & Description'!B$2:C$80,2,FALSE))

But you'll have to make that friendly name a little less friendly in the
original link.

=hyperlink("c:\...\kmb1020r.jpg")

or if the folder is always the same, you can embed it in your new formula:

=hyperlink("C:\...Fittings Spreadsheet\" & vlookup(...))

And if you wanted the friendly name to show:

=hyperlink("C:\...Fittings Spreadsheet\" & vlookup(...),vlookup(...))



Andrew said:
Well, hyperlink() did the trick for sorting, but I am having another problem.

I have a large sheet with one column that looks like this:

=VLOOKUP(F3,'Item # & Description'!B$2:C$80,2,FALSE)

The table_array (!B$2:C$80') that it refers to actually has hyperlinks like
this:

=HYPERLINK("C:\...Fittings Spreadsheet\KMB1020R.jpg","KMB1020R")

How do I link the hyperlink to the vlookup function?

Thanks
Andrew
Click to expand...
 
Thanks, that did the trick

Andrew

How about just using =hyperlink() once again:

=hyperlink(vlookup(F3,'Item # & Description'!B$2:C$80,2,FALSE))

But you'll have to make that friendly name a little less friendly in the
original link.

=hyperlink("c:\...\kmb1020r.jpg")

or if the folder is always the same, you can embed it in your new formula:

=hyperlink("C:\...Fittings Spreadsheet\" & vlookup(...))

And if you wanted the friendly name to show:

=hyperlink("C:\...Fittings Spreadsheet\" & vlookup(...),vlookup(...))
Click to expand...
 
Back
Top