Hi all,
I know this is a common question as I have seen numerous other threads on this topic. Unfortunately after hours of trial and error with these previous threads, nothing has been able to solve my problem.
As the title suggests, I'm looking to generate a formula (or code), which would display an image dependent on a specific cell value.
I have attached the example of what I am trying to do.
Basically I have 7 options (as shown in sheet 1), and 7 images corresponding to these options (shown in sheet 2). I wish to display an image in sheet one that is dependent on the contents of cell B3 in Sheet1 i.e. B3=Risk 1 then the image shown will be Picture 1, if B3=Risk 2 then the image will be Picture 2 etc.
Is there an easy way to solve this?
Many thanks in advance.
Display Image Conditional on Cell contents.xlsx
Bookmarks