"How to display product image when the product code was selected?" A group of participants from the retail industry asked that question during one of the past trainings. Their company, which was an American MNC retailer, carried thousands of products of many designs and for different segments of customers. For them, it was impossible to know the code of every product. So they wanted to know if Excel could display a picture of the product when the product code is selected. That would definitely make
the numbers they are analyzing a lot more meaningful.
At that point in time, I had some idea how it could be done with the OFFSET formula and the camera function in Excel but did not have the opportunity to get down working on it. When I finally did, I was pleased with the outcome of the solution.Because I am sure nobody ever thought that was at all possible. Watch the video and witness how the solution at work.
Download this "display product image" file and find out how it works.
Share this page:
Would you prefer to share this page with others by linking to it?
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft