![]() |
MS Excel IF Statement w/pictures?
is there a way to write a
statement in Excel (like an IF Statement), that would display a specific picture if a certain #/word/etc is typed in a cell? For example in A1 if I typed in ball, it would automatically bring up a pic I have saved of a ball in B1, whereas if I typed dog, it would put a dog in B1, etc..? If you know how to do this can you PLEASE email me at as its hard for me to check the Ngs at work... Thanks in advance Scott |
MS Excel IF Statement w/pictures?
Hi Scott
one method of doing something similar to this can be found at http://www.mcgimpsey.com/excel/lookuppics.html Cheers JulieD "Scott" wrote in message om... is there a way to write a statement in Excel (like an IF Statement), that would display a specific picture if a certain #/word/etc is typed in a cell? For example in A1 if I typed in ball, it would automatically bring up a pic I have saved of a ball in B1, whereas if I typed dog, it would put a dog in B1, etc..? If you know how to do this can you PLEASE email me at as its hard for me to check the Ngs at work... Thanks in advance Scott |
All times are GMT +1. The time now is 03:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com