How can I change a picture depending on a cell's contents

[LEP]

So I have a set of pictures imported into Excel on one worksheet

On another I have a table of data

On another I have a set of VLOOKUP functions that pull data from the table
dpending on user input.

I want to display a different picture depending on the results of the VLOOKUP.

 

[Gord Dibben]

To have a picture show up based on VLOOKUP when you select an item from a DV
list or type in a name see JE MCGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html

As written John's code allows for only one picture to be displayed and the
pictures must be stored on the same worksheet as the VLOOKUP formula.

Or you need multiple pictures shown from VLOOKUPS.............

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures via selections.

Allows for more than one picture to be displayed on a sheet but also requires
the pictures be stored on same sheet.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP