Display image based on value in a cell

[RodneyW]

How can I make a specific image appear based on the value of another cell?

For example, if A2 has the value of Apple, I'd like an image of an apple to display in a specific location. If the value in A2 is Banana, I'd like am image of a banana to display. All images are on my local drive in the same folder as the Excel file.

Thanks in advance

 

[Eric W]

Check out this link:

Picture Lookup in Excel using Named Ranges

Learn how to use Named Ranges to do a Picture Lookup in Excel. This is a cool excel dashboard trick where pictures update dynamically based on selections

trumpexcel.com

 

[RodneyW]

I think this is going to work. Wife is needing some help so I can't finish now, but I've made a lot of progress. Will update when completed. THANK YOU

 

[RodneyW]

I got it to work exactly as he's outlined it but my challenge is I need it to work off of a Slicer selection, not from a data validation selection. I'll keep working on it. Thanks for pointing me in a direction that will probably get me to the right solution.