Displaying photgraphs

[jinkysteve]

As a teacher I use randbetween to generate class register numbers when
choosing children for special assignments which, as 7 year olds, they can see
is the fairest way. Is there a way of making their photographs in a specific
cell (stored on our school network) appear if their number is generated? Many
thanks! Steve Thompson

 

[Dave Peterson]

JE McGimpsey shares how to do it with pictures:
http://www.mcgimpsey.com/excel/lookuppics.html