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.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Excel is great at printing numbers on a piece of paper, but terrible at printing watermarks. This is apparently by ...Discover More
Do you need to add a logo or other graphic to a bunch of worksheets? Here are a couple of short macros that can make ...Discover More
Don't like the way that Excel formats lines and arrows? You can easily make your own formatting changes, and then use ...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.