Pick a name from a drop-down and see its photo. In current Microsoft 365, put pictures in cells and XLOOKUP returns the picture directly. In older versions, use a linked picture driven by a named INDEX/MATCH formula.

Step 1: The drop-down
Names are in B3:B7 and pictures in C3:C7. Select F2 → Data → Data Validation → Allow: List → Source: =$B$3:$B$7.


Method 1: Pictures in cells (Microsoft 365)
- Select each picture → right-click → Place in Cell (or insert with Insert → Pictures → Place in Cell).
- In the result cell, type:
=XLOOKUP(F2,B3:B7,C3:C7)The picture itself is returned, and it changes with the drop-down. Resize it by changing the row height and column width. The IMAGE function works the same way for pictures from web addresses.
Method 2: Linked picture (any version)
Create a linked picture
Copy a cell with a picture (C3), right-click where you want it → Paste Special → Linked Picture. It’s a live view of that cell, and its formula bar shows =$C$3.



Create a named lookup
Formulas → Define Name, name it SuperHero, and in Refers to enter:
=INDEX(Marvel!$C$3:$C$7,MATCH(Marvel!$F$2,Marvel!$B$3:$B$7,0))

Point the picture at the name
Click the linked picture, and in the formula bar replace =$C$3 with =SuperHero.


A named formula is needed because a linked picture can’t take a formula directly, only a reference or a name.
Tips
- Make each picture fit inside its cell, or the linked picture shows part of the next one.
- Turn off gridlines (View → Gridlines) for a clean picture.
- Use it for product catalogues, staff photos or flags in dashboards.