View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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!