Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Displaying Images based on a Result.
by Allen Wyatt
(last updated February 6, 2018)
Dave has a large database that he keeps in an Excel workbook. It consists of material samples, and he uses the VLOOKUP function to generate various forms and reports. Dave wants to include a bitmap image on the form that changes according to one of the variables. For instance, if the form is describing an apple, then Dave wants a picture of an apple to appear; if describing a pear, then a pear should appear; and so on.
This is certainly a challenging task, but it is one that can surprisingly be done without macros. The steps are involved, but not that difficult to perform once you get to it:
Figure 1. The New Name dialog box.
Now, whenever the fruit name in cell A1 changes (which is, in turn, based on the value in cell G1), the image will change.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10450) applies to Microsoft Excel 2007 and 2010. You can find a version of this tip for the older menu interface of Excel here: Displaying Images based on a Result.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
A common way of representing data is to use a Venn diagram. Unfortunately, Excel doesn't have a precise way of creating ...Discover More
Graphics are a great addition to a worksheet, but there may be times when you don't want them printed. The easy way to ...Discover More
The camera tool allows you to capture dynamic "pictures" of portions of a worksheet. If you want to use the camera tool ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.