Display Product Image

April 20th, 2011 by admin admin

This solution is created with a combination of functions and formula. The frame for the changing image is created using the Camera function in Excel. Adding the Offset and Match formula make the address reference change according to the product code appearing in Cell H2. We use data validation to create a dropdown list for users to select the product code to display.

Leave a Reply

You must be logged in to post a comment.