Forum Discussion

Copper Contributor

Sep 21, 2023

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...

excel

Excel for web

Formulas and Functions

office 365

HansVogelaar
Sep 21, 2023
LiliaDubois

Here is an example that works with images stored in the workbook itself.
PictureDemo.xlsx33 KB

HansVogelaar

MVP

Sep 21, 2023

LiliaDubois

Recent versions of Microsoft 365 have a new function IMAGE

How will the image in cell B5 depend on the value in A5?

LiliaDubois

Copper Contributor

Sep 21, 2023

How will the image in cell B5 depend on the value in A5 : I want that the displayed image on the cell B5 changes depending on the value in the cell A5, it's like VLOOKUP but with images

HansVogelaar
MVP
Sep 21, 2023
LiliaDubois

Here is an example (requires Microsoft 365)
ImageLookup.xlsx56 KB
- LiliaDubois
  Copper Contributor
  Sep 21, 2023
  HansVogelaar Ooooh, thank you so much, this is exactly what I need ❤️ can you just please tell me the details, I'm really grateful
  - HansVogelaar
    MVP
    Sep 21, 2023
    LiliaDubois
    
    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.