inserting images in Excel, just wondering

[merlin_the_magician]

Probably a very dumb idea, but i was just wondering... would it be at all possible, to insert different images in excel, depending on a value?

Example:
If cell A1 contains value "10" insert image c:\image 12
If cell A1 contains value "20" insert image c:\image 15

 

[Iridium]

Don't know about inserting images but perhapsyou could try a hyperlink?

=IF(A1=10,HYPERLINK("c:\image 12.jpg", "Image 12"),HYPERLINK("c:\image 15.jpg", "Image 15"))

 

[merlin_the_magician]

this results in #NAME?

 

[Iridium]

Works for me - does the file you referenced in your formula exist and if so is the filename spelt correctly

 

[merlin_the_magician]

Refixed it to work with continental like this:

=IF(A1=10;HYPERLINK("c:\image 12.jpg"; "Image 12");HYPERLINK("c:\image 15.jpg"; "Image 15"))

images are in the right path, and names are correctly spelled. Still get the #NAME? thing...

 

[Iridium]

Having searched the xl help file on #NAME? it says causes can be

• Misspelling the name of a function (is HYPERLINK something else in the Dutch edition of xl?)
• Misspelling the name
• Deleting a name used in the formula, or using a name that does not exist
• etc.

so I'm a bit stuck for ideas now

 

[merlin_the_magician]

Stupid, stupid, stupid....

IF needs to be altered into ALS (Dutch)....

One more thing... imagine i have, let's say 25 images i want to link to through 25 different possible numbers in cell A1, do i just need to create a huge formula referring to all these images, or is there an easy way?

 

[Iridium]

IF needs to be altered into ALS (Dutch)....

Perhaps I should have known that too - my girlfriend is Dutch!

Any way with IF (or ALS) there is a limit of seven nested statements - perhaps someone could help with a VLOOKUP (or Dutch equivalent)?

 

[merlin_the_magician]

shame on you....! :D :D

Hmm... i remember something like that yes... i'll try and figure out a formula using "substitute" or something.

Thanx!

 

[Iridium]

Possible solution

I've sent you a PM but just to make sure drop me an e-mail to get your e-maill address to chrisjchattin(at)yahoo.co.uk - replace (at) with the symbol