Image from URL

[rik1603]

Hello all,

Having a bit of a problem with images in Excel

I have sheet2 which contains on over 5,000 products with values such as product code, description, price etc and the image URL.

In sheet1 I have a 'quote form' which exacts the relevant information using a vlookup and displays it in a presentable format.

All works fine except I need a solution to show the image in the quote from by looking up the product code.

My preferance would be to embed the image from the url into a cell using a vlookup but if anyone has any soltuions to this I would be grateful.

Thanks!

 

[rik1603]

If the above isn't possible, as a quick fix, does anyone know how to turn a URL into a hyper link?

I.E. cell O2 contains a URL, I would like cell P2 to show 'Click here' with a hyper link to cell O2's URL.

Obviously the original post is my preference but if anyone could provide a formula for this one it would certainly get me by!

Thanks.

 

[rik1603]

If the above isn't possible, as a quick fix, does anyone know how to turn a URL into a hyper link?

I.E. cell O2 contains a URL, I would like cell P2 to show 'Click here' with a hyper link to cell O2's URL.

Obviously the original post is my preference but if anyone could provide a formula for this one it would certainly get me by!

Thanks.

For future reference if anyone needs to solve the above problem you can just use the HYPERLINK function (doh!)

 

[rik1603]

I guess my original plan ins't possible then? (Showing an image from a url via a vlookup or similar)

 

[jim may]

Will this help you?

http://www.mcgimpsey.com/excel/lookuppics.html