Link, Lookup or macro to display a picture

[Clonemonkey]

ok so do I need a formular or macro? (ps rather have a formular)

if cell A1's value is populated from a Lookup formular I want a specific photo to appear next to it.
ie: A1 = "dog" so photo "dog" is there,
if A! = "cat" then photo 'cat' pops up
if A1 = "bird" then "bird" appears.

photos may be stored on sheet2 if that helps but I'm not sure how to call them "dog", "cat" etc either.

thanx Matt.

 

[Akashwani]

Hi Matt.

Take a look here....

Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function - YouTube

Learn Excel 2010 "Dynamic Pictures": Podcast #1417 - YouTube

I hope that helps.

Ak

 

[Clonemonkey]

Yes it did, awaesome link, exactly what I wanted.
Although there were a couple of things not 100% correct:
He mentioned the cell with the source pic had to enclose the image but as long as it's top right corner is in the cell you want, it's all good.
Same goes for the target, I couldn't re-size the area as I had many cells on several rows to the left occupied so I just merged cells over 3 collumns & 6 rows... DONE.
Also I added to the formular to allow for my trigger cells causing a N/A responce: I put IFERROR([my formular],"") so all good.

Matt.S.

 

[Akashwani]

Hi Matt,

I'm pleased you found the link beneficial, Mike has loads of great Excel videos and thanks for the feedback.

Ak