ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MS Excel IF Statement w/pictures? (https://www.excelbanter.com/excel-programming/323309-ms-excel-if-statement-w-pictures.html)

Scott

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

JulieD

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