Showing image when name selected from drop down list

[solvent4130]

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

[patel45]

Please Login or Register  to view this content.

[solvent4130]

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

[patel45]

attach the modified file again

[solvent4130]

Thanks, sorry here it is.


drop down test 1-1.xlsx

[patel45]

xlsx file does not have macro, how can I check your code ?

[HaHoBe]

Hi, patel45,

why donīt you attach the working xlsm workbook with your code included? That could be the best of all solutions.

Ciao,
Holger

[solvent4130]

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

[HaHoBe]

Hi, solvent4130,

maybe you could mark this thread as solved via ThreadTools.

Ciao,
Holger