Showing image when name selected from drop down list

Hi Everyone, i am a relatively new excel user and this is my first post here. I have created a comparison sheet which has 3 drop down menus and this populates the cells with the correct data using VLOOKUP. Ideally i would like to show the image of the printer also when selected. I have read around online and tried various things but i cant get it to work. I would be very grateful if someone could take the time to check it out for me. I assume a macro could do this but I am really not sure where to start.

i couldn't get it to attach so i have included a link. http://www.filedropper.com/dropdowntest1-1

many thanks

Thank you for the reply. I can get it to add the first picture but then i cannot use the drop down list to change it. i am probably doing something wrong. thanks for looking and hopefully this is going in the right direction!

many thanks

Thanks, sorry here it is.


drop down test 1-1.xlsx

Hi All, i managed to get what i needed by using INDEX and MATCH. Thank you to everyone that looked at this for me.