Formula for Pictures

[ronie85]

I have a main template in Sheet 1 that I have a drop down selection which fills in all the cells using info on Sheet 2.
I also have pictures on Sheet 3 and can allocate pictures to each of the selections within the drop down box.

Can someone advise if there is a formula to copy the picture into the main template once its selection has been made in the drop down box?

Assume;

Dropdown Box selection is Sheet 1 Cell A1
Picture needs to go into Sheet 1 Cell B5
Picture for this Drop Down selection exists in Sheet 3 Cell B5, the text for it is in A5.

Thanks in advance.

 

[ISY]

Hi

=VLOOKUP

 

[ronie85]

Hi

=VLOOKUP

Will this work with a picture though? And does the text that VLookup searches, need to be in the cell behind the picture?

 

[ISY]

Hi