I saw a previous post that refered me to
Maybe something for you at John McGimpsey's site.

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


and I am able to get this to work if i only have ONE picture that needs to
be displayed per worksheet. But i have the scenario there I look up the
pilot flying in A2 and need to display the photo in G2 for a range of rows
2:10

I altered the Marco to have a range of "a2:a10"
but i still only get a photo for the first row it finds. For all subsequent
rows the "formula" in G3 - G10 shows the correct correlating picture name but
no picture is displayed.

Any help would be greatly appreciated. THanks - JB