Forum Discussion
Solved
Insert a conditional image into a cell
Hello everyone, I have two questions and I'm struggling to find the answer. How can I insert an image into an Excel 365 cell without using macros? Additionally, I want the image in cell B5 to chang...
Here is an example that works with images stored in the workbook itself.
The picture over cell B5 has been created using the Camera Tool
I also created a defined name Pic. You can see its definition in Formulas > Name Manager: it refers to
=INDEX(Sheet!$B$30:$B$31,MATCH(Sheet!$A$5,Sheet!$A$30:$A$31,0))
It looks up the cell containing the picture corresponding to the description in A5.
I selected the picture over B5 and entered the formula =Pic in the formula bar. This is the "magic" that causes the image to change depending on the value of A5.
Thank you very much !!
