How to Lookup an Image in Excel: Build a Searchable Picture Gallery

To look up an image in Excel or WPS Spreadsheet, build a two-column table of names and pictures, link each picture to its cell, then use a data validation dropdown with INDEX and MATCH to swap images instantly. This creates a searchable picture gallery that works like a photo lookup without VBA or macros.

How to Lookup an Image in Excel: Build a Searchable Picture Gallery

How to Set Up the Image Lookup Table

Every image lookup starts with a clean data table where the picture column sits next to the name column. The name column is the lookup key; the logo column holds the images that will be shown:

1. Create two columns: label the first one Name and the second one Picture (for example Club Name and Logo).

2. Insert your images in the Picture column, one picture per row, resized to roughly the same dimensions.

3. Keep the rows aligned: every image must sit in the same row as its name, or the lookup returns the wrong picture.

The table below is the classic setup, with club names and their logos in matching rows:

Excel picture lookup data table

How to Create the Image Lookup Dropdown

A data validation dropdown turns the gallery into a searchable picture lookup: you pick a name, and the matching image appears. To build it:

1. Click the cell where you want the selector (for example E3), then open Data > Data Validation.

2. In the Allow box, choose List and set the Source to the name range, such as =B3:B22.

3. Click OK. A dropdown arrow now appears in the cell, listing every name from the lookup table.

The Data Validation dialog below uses the name list as the dropdown source:

Excel data validation dropdown list

How to Link the Lookup Image to a Name with INDEX and MATCH

Spreadsheet cells cannot hold a formula result and a picture at the same time, so the image itself must be linked to a result cell with a named range. The formula =INDEX(C3:C22, MATCH(E3, B3:B22, 0)) finds the row of the selected name and returns the picture stored there:

1. Select the picture range (C3:C22) and open Formulas > Name Manager; create a name such as Pictures.

2. Copy the picture from the table, paste it near the dropdown, and in the formula bar set it equal to the INDEX MATCH formula that returns the picture.

3. Select a name from the dropdown; the linked picture changes to that name's image.

The Name Manager below shows the INDEX MATCH formula behind the linked picture:

Excel name manager index match formula

The Best Free Alternative: WPS Office

WPS Spreadsheet supports the same picture lookup workflow, including data validation lists, Name Manager, and INDEX MATCH formulas, with full .xlsx compatibility. That means galleries you build in Excel open and keep working in WPS Office, and vice versa. The free suite also bundles Writer, Presentation, and a PDF toolkit for exporting your gallery as a shareable report.

WPS Spreadsheet data and formats

FAQs

Can Excel look up and display images automatically?

Yes. Link a picture to an INDEX MATCH result with a named range, then pick a name from a data validation dropdown and the image swaps automatically.

Why is my lookup picture not changing when I select a name?

The picture is probably not linked to the formula. Paste the image, click the formula bar, and type the INDEX MATCH formula so the picture equals the returned value.

Do I need macros for a picture lookup in Excel?

No. Data validation, Name Manager, and INDEX MATCH do the whole job without VBA, and the file stays macro-free and easy to share.

Does WPS Spreadsheet support picture lookup?

Yes. WPS Spreadsheet supports data validation lists, named ranges, and INDEX MATCH, so the same picture lookup workflow works with full .xlsx compatibility.

How do I resize images before building the gallery?

Insert each image, hold the corner handle, and drag to roughly the same height; then align the pictures with the rows before creating the named range.