Can you change a picture when different drop down items are selected in a combo box

[si.lav]

I am creating a search tool and a member of the business selects a
particular vendor a series of information comes up including the name
of the employee who looks after that vendor. Is it possible to have a
space for a picture that changes when that name changes?

Thanks in advance.

Si

 

[JE McGimpsey]

Here's a way to do it with validation dropdowns:

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