I want to place a linked picture object on a worksheet such that the link
address is part of a referencing function (such as vlookup) so that when I
change a parameter of the vlookup function, the picture will also change
accordingly.

Date 1 | PicDirectory1
Date 2 | PicDirectory2

so that when i place a vlookup function and place date1 as a parameter, the
picture links to PicDirectory1 and when i change the vlookup function
parameter to Date2, the picture also changes accordingly, linking to
PicDirectory2.

Is this Possible at all?