Is it Possible to Use a Vlookup to Pull In Image?

[dmill8023]

Hello All! I want to see in this post if it is possible to have some images located on one worksheet and then use a vlookup formula to pull in images to another worksheet? I currently have a dropdown that changes cities in D6 on a worksheet. I want to have the functionality to adjust the value in D6 and have a corresponding image change from city to city...

My first question is simply is this possible? If so, does anyone have a good link that teaches or can someone walk me through the steps of building the formula or logic?

Thank you and let me know what other information I can provide.

 

[Domenic]

Have a look here...

Blog

Hope this helps!

 

[dmill8023]

Do my pictures need to be the same size or can they vary, do you know? Also, can this work between 2 different worksheets or does it have to be on the same worksheet?

Thanks for the help, working on getting it to work unsuccessfully.....so far that is!

 

[dmill8023]

Also, does this only work with a certain picture type??

 

[Domenic]

Here's a sample workbook...

https://onedrive.live.com/redir?resid=41260C1C818928B2!657&authkey=!ADa_q0NIX0HO7vE&ithint=file,xlsx