Only by using VBA

See John McGimpsey's site for one method suing Event code, Data Validation
and VLOOKUP formula.

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

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

Alows for more than one picture(or same picture multiple times) to be
displayed based upon a value or item chosen from DV lists

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

DV0049 - ClipArt Selection

Edit the code to suit.


Gord Dibben MS Excel MVP

On Fri, 14 Nov 2008 17:02:01 -0800, ForeverH
wrote:

Can you use the IF formula to insert a jpg?