Fix a picture to a cell

[DaddyH]

Hi guys, i'm sure this can be done, but am struggling slightly.

I'm doing a basic vlookup for 20 or so cells, however one of the matched cells needs to find a picture. Can I attach a picture to a cell so when the vlookup finds the match the picture is shown?

Cheers Guys!

Thanks for reading and your help.

Regards

Nick

 

[DaddyH]

Hi Guys, your help would be greatly appreciated! if it can't be done could you suggest another way of doing it please?

Cheers

 

[GlennUK]

What picture? Are they stored in the workbook somewhere?

 

[DaddyH]

Yep, yes currently it is inside the cell itself from where the Vlookup will be picking the info from.

Cheers

 

[GlennUK]

Is this any use:

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

 

[snoopyhr]

try this link:

http://www.youtube.com/watch?v=MzF_5DXhqbs