Can you use a formula to automatically display a picture in a cell
 

I have one worksheet in my workbook with several different pictures of
furniture, among other data. I have set up a template on a second worksheet
to pull in the data in a formatted page using a list dropdown and several
different formulas on the page. I would like to know if I can use a fomula
on the second worksheet to automatically pull in a picture of the item from
the first worksheet. Is that possible? Is it easier to do it a different
way, i.e. maybe put all pictures in a directory on my hard drive and have
them pull in and display from there? Please help!
Thanks!

Can you use a formula to automatically display a picture in a cell
 

You may be able to adapt the technique he

http://www.mcgimpsey.com/excel/lookuppics.html


In article ,
Suthey1 wrote:

I have one worksheet in my workbook with several different pictures of
furniture, among other data. I have set up a template on a second worksheet
to pull in the data in a formatted page using a list dropdown and several
different formulas on the page. I would like to know if I can use a fomula
on the second worksheet to automatically pull in a picture of the item from
the first worksheet. Is that possible? Is it easier to do it a different
way, i.e. maybe put all pictures in a directory on my hard drive and have
them pull in and display from there? Please help!
Thanks!