Insert picture from URL with a vlookup

[jamieray]

Hi All,

I’m new and this is my first post after looking on here many times in the past so please be gentle

I’m struggling to get the following done and not really sure where to start!

I have a spreadsheet with 2 sheets, sheet 1 i need to insert a picture from a URL that has to be looked up from sheet 2

What I need it to do:

In cell A2, look up a code that is in C2 and return the URL that is located in sheet 2 in cell C2

=VLOOKUP(C2,'datafeed_United Kingdom'!1:1048576,3,FALSE) is what i have used for that part

This will give me the URL I need in cell C2.

Now this is the part I’m struggling with - then I need the picture from the URL returned into the cell (C2) and then to proceed to the cell below A2 and to the same, and so and so on

(I have already made the cell heights 204 and centred the text)

I need this to happen for 532 rows, sometimes more so you can see why I don’t want to do this manually!

Im using Excel 2007

Any help would be gratefully appreciated

Many thanks in advance and please tell me if you need any more info or if i have missed anything out or if this is even possible??

Jamieray