How to add picture based on a cell value

[Guest]

Any body from excel experts,plese help me how to add a picture based on a
cell value.I have excel sheet has persons personal data,I would relates that
data with their photo.How to create picture table,add pictures,looking up and
displaying pictures based on a cell value.

 

[JE McGimpsey]

See

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

 

[Guest]

Thank you JE McGimpsey.I am a raw learner in excel I am uanable create
pic.Table in sheet2 as you described in your sample worksheet.,which I have
downloaded.My photos which I want to add are in 'my pictures file'.I wrote
names of persons in sheet 2 col A (a2:a4) and in col B in b2 I entered
=picture1,It gave me error 'NAME'.How to do this task.It may be easy task for
you.Please guide me.

 

[Guest]

A million thanks to JE.I have done it with your help and guidance.You won't
believe this is my life's first macro I have added to my excel sheet.I would
like to know how to replace picture1 or any picture with other latest picture
of same person.