Here is an update to a previous post on pulling photos using a drop down list. In this video we talk about how to use spaces in the names and incorporating multiple choices in one worksheet. We will utilize the VLOOKUP and INDIRECT functions in the process.
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
Here is the link to the original blog post video.