Picture Lookup in Excel

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.

Microsoft 365Place in Cell + XLOOKUP
Any versionLinked picture + named formula
ExampleSuperhero drop-down

Picture changing when a name is selected from the drop-down

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.

Data Validation list for the drop-down
Drop-down list of names

Method 1: Pictures in cells (Microsoft 365)

  1. Select each picture → right-click → Place in Cell (or insert with Insert → Pictures → Place in Cell).
  2. 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.

Copying the cell that holds a picture
Paste Special Linked Picture
Linked picture pointing to another cell

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))
Define Name on the Formulas tab
Named formula SuperHero

Point the picture at the name

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

Linked picture formula changed to the name
Picture updating with the drop-down

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.

Related

Last updated · Written by Ajay Anand, Microsoft Excel MVP