Try JE McGimpsey's page at:
http://www.mcgimpsey.com/excel/lookuppics.html
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AJ" wrote:
Hi there,

Lets say in Sheet 2 I had pasted 3 pictures

On sheet 1:

A1=1
A2=2

Is it possible to put a formula in B1 that has this logic:

If A1=1 then show picture 1, otherwise show picture 3

I doubt its possible, but you never know eh.



or, if I have 3 images saved on my harddrive, can I use a formula to show
the image in a spreadsheet without having to insert/paste it in?

Many thanks,

AJ