LOOKUP A .JPG

[lehigh46]

Hi All

This may sound far fetched but;

Is it possible create a formula that sits in B2 and looks for a path
and file name in A2, then incerts a .jpg picture in B2.

Or anything similar to the above dream.

Thanks for your help


Tom Snyder

 

[Frank Kabel]

Hi
not directly the picture but a hyperlink to it:
=HYPERLINK(A2 & ".jpg",A2)
in cell B2