Can Excel select a picture?

[Fluffy]

How can this be done?

If the text in cell A1 is the name Jane then a picture of Jane appears
in cell B1.
If cell A1 is Bill then a picture of Bill appears in cell B1.

 

[Dave Peterson]

J.E. McGimpsey shares this in a macro at his site:
http://www.mcgimpsey.com/excel/lookuppics.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm