Mar 13 2022 05:41 PM
I am trying to insert an image into a spreadsheet from a conditional formula.
As example:
=If(Moon = "Full",Image1,if(moon ="New",Image2,NoImage)
Image1 = Full Moon.jpeg
Image2 = New Moon.jpeg
No Image = (Blank Cell)
Mar 14 2022 12:19 AM
SolutionI don't know of any way to insert an image using VLOOKUP or any other standard function.
But you can define a function yourself and accordingly insert images after selection.
Here is a small example file how to do it.
It could also be done with VBA.
I would be happy to know if I could help.
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Mar 15 2022 02:16 PM
Mar 16 2022 03:11 AM
Mar 14 2022 12:19 AM
SolutionI don't know of any way to insert an image using VLOOKUP or any other standard function.
But you can define a function yourself and accordingly insert images after selection.
Here is a small example file how to do it.
It could also be done with VBA.
I would be happy to know if I could help.
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.