S
Soundman
Hi all,
This seems like a simple problem, but here I am anyway. I have a serie
of simple pictures in a spreadsheet. Depending on what the user input
into A1, I want A2 to show the corresponding picture. For example i
the type "cat" in A1, the A2 would show a picture of a cat. The pictue
are already in the spreadsheet, it's just a matter of finding a functio
that will copy the cell that it's in & paste it into A2. If I manuall
copy & paste the cell it works, but I'm looking for a formula that ca
do that.
I've also tried naming the picture & using an if function. IE: =i
(A1="cat",cat,""). But what that did was paste the words "group312" i
the cell instead of the picture.
I prefer to keep this away from turning into a VB project.
Can anyone help?
Thanks,
Bil
This seems like a simple problem, but here I am anyway. I have a serie
of simple pictures in a spreadsheet. Depending on what the user input
into A1, I want A2 to show the corresponding picture. For example i
the type "cat" in A1, the A2 would show a picture of a cat. The pictue
are already in the spreadsheet, it's just a matter of finding a functio
that will copy the cell that it's in & paste it into A2. If I manuall
copy & paste the cell it works, but I'm looking for a formula that ca
do that.
I've also tried naming the picture & using an if function. IE: =i
(A1="cat",cat,""). But what that did was paste the words "group312" i
the cell instead of the picture.
I prefer to keep this away from turning into a VB project.
Can anyone help?
Thanks,
Bil