Using IF function to bring up a picture

[FRIJOE]

Hello,

I have a form I'm attempting to add automatic graphics to and require assistance. I've found a few sites that detail how to link a picture to a cell but unfortunately am having problems getting this to work. Any assistance is greatly appreciated.

Background:
I have some lines in a form, where if filled out, a picture will automatically pop up.
If you start filling out the next line, a different picture will pop up.

What I have so far:
Lets say I have three pictures (Picture1, Picture2, and Picture3).
The location of Picture1, Picture2, and Picture3 are currently on 'Sheet2'!$A$1:$A$3
The rest of the information is on Sheet1
=if(b2=1, a2=Picture1 ,if(b2=2, a2=Picture2 ,""))
=if(b3=1, a3=Picture1 ,if(b3=3, a3=Picture3 ,""))
=if(b4=2, a4=Picture2 ,if(b4=3, a4=Picture3,""))

What I want:
Any of the pictures could be used multiple times, and displayed at the same time in different cells.
Based on the value of one cell, I want the picture to appear in another cell.

Any help is greatly appreciated. Thank you

 

[pgc01]

Hi

I posted how to do it here:

https://www.mrexcel.com/forum/excel-questions/760583-changing-picture.html

 

[FRIJOE]

Thank you very much PGC!

 

[pgc01]

You're welcome.