.xls guru please. ...
 

MegaSack DRAW - This year's winner is user - rgwb
We will be in touch

[Closed] .xls guru please. Vlookup to pull hyperlinks too?

1 Posts
2 Users
0 Reactions
60 Views
 benz
Posts: 1143
Free Member
Topic starter
 

2 lists.

1 list has complete data set including hyperlinks to images.

I have multiple other lists into which I want to use inventory number as common lookup and I'll pull across the hyperlinks associated with each inventory number.

Unfortunately whilst something that looks like a hyperlink pulled in when I click on it it does not recognise.

Ant thoughts?

Thanks.


 
Posted : 23/12/2015 9:02 pm
Posts: 0
Full Member
 

http://stackoverflow.com/questions/2595692/how-do-i-convert-a-column-of-text-urls-into-active-hyperlinks-in-excel

You need to set the target cell type as hyperlink
eg =hyperlink(vlookup(ref, range, count))


 
Posted : 23/12/2015 9:10 pm