How To Show A Blank Option With Select Photos From A Drop Down List In Excel

In this video we’ll take a look at how to modify previous videos I’ve done on pulling in photos tied to a drop down list by adding an option so that if nothing is selected, a blank cell will appear.

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.

Previous blog posts on this topic are listed here:

Original Post
Update
For Excel 2007
Common Errors
Photos From Checkboxes

The easiest way to understand this process is to watch the video from the original post (or review the text of that video). Once you understand the process, the steps to allowing for a blank entry are:

1) Create a cell with the name “blank” – don’t insert anything into that cell
2) Modify the formula for the WinePhoto Name Manager entry from:

=INDIRECT(Catalog!$C$2))

to:

=IF(ISBLANK(Catalog!$C$2),INDIRECT(Data!$A$6),INDIRECT(Catalog!$C$2))

This will check to see if the drop down list is blank. If it is, it will insert the blank cell. If it is not, it will pull the image located in the cell that is referenced in cell C2.

And that’s all there is to it!

What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , ,

No comments yet.

Leave a Reply