Not using a formula.

But you could use a macro.

JE McGimpsey shares how to do it with pictures:
http://www.mcgimpsey.com/excel/lookuppics.html

Pjotr70 wrote:

I just have p.a. 5 pictures in sheet 3 as a master.

In sheet 1 I like to show just 1 of the 5 pictures on sheet 1 on a special
place depending on a value in cell A1. With figures it is possible with
vloopup/hlookup but how to magae with pictures?

--

Dave Peterson