Import image address from website into excel

[Deppdallin]

I am wondering if anyone knows a way to import an image address from a website using a particular cell to refrence. Example : C2 says "javelin nordic 800mg" I would like it to find what cell C2 says and import the product image associated with that particular word. Is there any way to do this ?

 

[WassimN]

Hi Deppdallin

OK I tried this and got this to say:

I used your term "javelin nordic 800mg" to search using Google Images and I got this:
https://www.google.com/search?hl=en...z-img.....0.UPhOtXtU6CI#imgrc=pNcJyS9jD--MkM:

Then as a test I searched for an image using "lamborghini aventador sv" and got this one
https://www.google.com/search?hl=en........2....1..gws-wiz-img.....0..0.2y8XWkTK9GQ

Then I searched for an image using "diet coke bottle" and got that one:
https://www.google.com/search?hl=en...1..gws-wiz-img.....0..0i67j0i7i30.Jo1G8fRoAMo

Now I can't tell what all that means, but you can see that:

https://www.google.com/search?hl=en&tbm=isch&source=hp&biw=1350&bih=737&ei=cSP0W6PGOq-l_QbA6Y_4Cg&q=

appears in the first two searches (but not the 3rd) and then the search term(s)

maybe you can try and make some manual searches and see the URL string and just add the cell content in the format that the URL can accept (+ in between the words) and see if you can come up with a URL for the images you need.

I hope this means you have a few images to process but if you have many, I guess a more detailed information reply would be nice.