Image from URL

R

rik

Joined
Mar 15, 2011
Messages
4
Reaction score
0
Hello all,

Having a bit of a problem with images in Excel :confused:

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!
 
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.
 
rik said:
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.
Click to expand...

For future reference if anyone needs to solve the above problem you can just use the HYPERLINK function (doh!)
 
I guess my original plan ins't possible then? (Showing an image from a url via a vlookup or similar)
 
Back
Top