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.

"JE McGimpsey" wrote:

See

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


In article ,
TUNGANA KURMA RAJU wrote:

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.