VLOOKUP can't handle pictures ? ALTERNATE ?

[makinmomb]

I have this on sheet1 on B2 and B3 , where war-200 is chosen through drop down menu , while another sheet named pics has war-200 on A1 and its picture on b1 , is there a formula to throw the picture on C3 of sheet1 from table of code and pictures

Select Code

WAR - 200

<colgroup><col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;"> <tbody> </tbody>

 

[AhoyNC]

See if this link is any help.

https://www.youtube.com/watch?v=MzF_5DXhqbs

 

[jamtay317]

I have this on sheet1 on B2 and B3 , where war-200 is chosen through drop down menu , while another sheet named pics has war-200 on A1 and its picture on b1 , is there a formula to throw the picture on C3 of sheet1 from table of code and pictures

Select Code

WAR - 200

<tbody>
</tbody>

I would use a vba change event.