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.