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.

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))