Display Image Based on Excel Formula

TOO GOOD SIR REAL SMART TEACHER

i don't know how you set the same name to a cell and an image, but my excel isn't liking it.

Hi I am uanble to get the Picture and when i click on the pic define name after selcting its showing some error

Hi All, 

I'm trying to find a way to have 3 parameters in excel. This will be linked to Power Bi, and it will change the image according to the value. I know how to do it with 2 parameters (yes/no). 

Attached image is quite self-explanatory. 

thanks,

Hi sir Greg! Is this possible in google spreadsheet? Nice work btw.

Hello sir can we run macro on this image

can you do a tutorial on how to link the inserted image in different worksheet? then if you change the inserted image, all the images with the same image that linked to the inserted image will also change in different worksheet at the same time.

Cool!

How do I do this for more than 2 pictures?

This is by far the simplest way to do this. Excellent!

Simple and very useful. Thank you!

Great Video! Thanks for sharing your knowledge!

Great job but i still have a little problem. I get an error message when i type my formula. =IF(A2=111, "p111e", IF(A2=112, "p112e", IF(A2=113, "p113e"))). Note that i have three pictures p111e, p112e, p113e and my cell value at A2 cell is a calculating value from other cells. Can you help me please?

Nice totorial hahaha good

I'm trying something a little different and can't solve it. I have a column of images and I want to display them on a floating shape. It works with text. Example: I have a list of soccer players with positions and Jersy numbers. I can add a formula to populate the shape with names, positions and numbers. Those shapes float anywhere on the the spread sheet. When I try to do the same with the player's picture, the shape does not populate.

Hi Greg, would it be possible to make it dynamic by changing braintek.png to fairbanks.png. I would like to use it with filenames instead of manually inserting all files. I have thousands of image file and I don't want to load them into the excel spreadsheet. Thanks! :-)

This doesn't work.

Reference is not valid why???

Hey man, I cannot get this to work. No matter what I do, I cannot name a cell and a picture the same thing. Any tips? Any settings I need to tweak? I'm using Office 365. Thanks!

hey how did you overcome the "Reference not Valid" pop-up from Excel?

Very helpful. Thanks for illustrating this. It's a surprisingly complicated process; nice to see someone doing it in a video. Going to "Define name" rather than using the upper left Name Box -- so you can change the value of the formula to INDIRECT(original address here) -- was the tricky part, I thought.

Hi Greg,How would you do this if you are working with a spreadsheet.  Column A is an image; Colum B is a number. you have ten rows and you want the image to populate based on the number you place in column B on row 1-10.

Excel 2007 wont allow me to name both the cell and picture the same, how can I get around this issue?

HiThe "=picture" bit at the end didn't work.It tells me "Reference is not valid"