I am tring to find a way to insert pictures either from file or another
worksheet based on the lookup function that is in the cell.
Cell a5 (all row 5) has a function to lookup a list (a1:b365) on sheet 2
based on the value in cell a4 (all row 4). If there is nothing in column b
for the lookup value I want to do nothing. If there is something in column b
matching up with my value I want to put a picture in the same cell with the
text.

For example a4 is Jan 1, a5 is lookup function, a1:b365 is list of all dates
and significance of date (holiday, birthday,etc)
Lookup function in a5(Jan 1) displays text "Happy New Year" and I want to
put a picture for the occasion. b5(Jan 2 ) is nothing special so no text is
displayed and I dont want a picture in this cell.

If you have any ideas, please let me know. I can either insert pics lined
up with date in c1:c365 of sheet 2 or I can put the filename and location
(example___ c:\my pictures\pic001) in these cells. Whatever would be easier.

Hi,

Functions return values they do not modify the GUI (user interface) - a
spreadsheet function can't display a picture depending on its value. You
option is to impliment something in VBA programming.

For that we would need to know where the picture is located, its name, what
exactly is going to trigger its display, what you want to do if the return
value change to one that wouldn't have displayed the picture. Do you want to
delete the picture or hide it or what.

Maybe the best starting place is to put all the pictures you want in the
file manually and then tell us what their names are. Objects, like picture,
are named by Excel automatically.

Cheers,
Shane Devenshire

"Danny" wrote:

I am tring to find a way to insert pictures either from file or another
worksheet based on the lookup function that is in the cell.
Cell a5 (all row 5) has a function to lookup a list (a1:b365) on sheet 2
based on the value in cell a4 (all row 4). If there is nothing in column b
for the lookup value I want to do nothing. If there is something in column b
matching up with my value I want to put a picture in the same cell with the
text.

For example a4 is Jan 1, a5 is lookup function, a1:b365 is list of all dates
and significance of date (holiday, birthday,etc)
Lookup function in a5(Jan 1) displays text "Happy New Year" and I want to
put a picture for the occasion. b5(Jan 2 ) is nothing special so no text is
displayed and I dont want a picture in this cell.

If you have any ideas, please let me know. I can either insert pics lined
up with date in c1:c365 of sheet 2 or I can put the filename and location
(example___ c:\my pictures\pic001) in these cells. Whatever would be easier.

I appreciate you trying to help me. Let me see if I can explain what I am
trying to do better. I understand that more than likely it needs done all
manually or through vba. I have probably about 100 pictures that I need
inserted so I was looking for a way to do it through programming. I have a
list of all the dates with the significance of the date beside it A1:b365 (on
sheet 2). I have looked at inserting pictures through programming and found
that you can insert a picture with the file name. I was thinking that I
should be able to put the file name in the list in column "c1:c365(sheet 2)"
matching up with the date. And some way to look up the date and insert the
picture using the file name in cell c (c:\mypictures\IMG_001.jpg).

Therefore if the function that looks up the date and returns the value in
the cell below it. So if I change row b which will change the return value I
will also change row c. But if the return value is changed I would want the
pic deleted.
For January columns (a:g)
Dates are in rows 4,6,8,10,12 starting with e4 and ending in g12
Lookup function below each date row in rows 5,7,9,11,13 staring e5 ending g13
Significant dates e4:e5, d6:d7 , e8:e9 , a12:a13 , d:12,d:13 , f12:f13
The date is in the first block and a line of text from the lookup function
is in the second block. I also want a picture in the second block.
Lookup list cells associated w/ these dates
a1:b1,a7:b7,a15:b15,a25:b25,a30:b30 (sheet2)
I put the pictures in column c (sheet 2) of these lines and they were
labeled by excel Picture1,Picture2,Picture3,Picture4,Picture5

If you could help me out with this, I am sure I could make it work with the
rest of the months. My main problem is trying to figure out how to to tell
excel to insert the picture associated with the correct date. If this cant be
done with filenames or pictures in column c where would I need to put them.

"Shane Devenshire" wrote:

Hi,

Functions return values they do not modify the GUI (user interface) - a
spreadsheet function can't display a picture depending on its value. You
option is to impliment something in VBA programming.

For that we would need to know where the picture is located, its name, what
exactly is going to trigger its display, what you want to do if the return
value change to one that wouldn't have displayed the picture. Do you want to
delete the picture or hide it or what.

Maybe the best starting place is to put all the pictures you want in the
file manually and then tell us what their names are. Objects, like picture,
are named by Excel automatically.

Cheers,
Shane Devenshire

"Danny" wrote:

I am tring to find a way to insert pictures either from file or another
worksheet based on the lookup function that is in the cell.
Cell a5 (all row 5) has a function to lookup a list (a1:b365) on sheet 2
based on the value in cell a4 (all row 4). If there is nothing in column b
for the lookup value I want to do nothing. If there is something in column b
matching up with my value I want to put a picture in the same cell with the
text.

For example a4 is Jan 1, a5 is lookup function, a1:b365 is list of all dates
and significance of date (holiday, birthday,etc)
Lookup function in a5(Jan 1) displays text "Happy New Year" and I want to
put a picture for the occasion. b5(Jan 2 ) is nothing special so no text is
displayed and I dont want a picture in this cell.

If you have any ideas, please let me know. I can either insert pics lined
up with date in c1:c365 of sheet 2 or I can put the filename and location
(example___ c:\my pictures\pic001) in these cells. Whatever would be easier.