Return a Picture

[PorknCider]

Can anyone tell me how to return a picture (jpg, gif etc) instead of a Value?
For Example:
=IF(A2="Jim","Return Picutre","")

Cheers in advance

 

[bat17]

See if this article fits your needs.

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

Peter

 

[k9nny]

Hello All,

I am looking to use the McGimpsey solution featured in this thread to displaying images based on a cell value. However I have a question. I can see how the named range and vlookup formula works, but can anyone tell me how the images are named, and how I can see these names?

Thanks, Kenny.