Creating an inventory spreadsheet for my girlfriends business she is starting up, which includes a ton of photographs. Is it possible to use a hyperlink to an image, based on the value of a cell in the row?
For example: if the images are located in ..\..\Pictures\*.jpg and I have a inventory record # associated with that photograph, can i link to it?
example: assume the hyperlink is in a cell on row 5 and the * references the value in Row 5, Column B
=hyperlink(..\..\Pictures\*.jpg,"photo")
The table this will go in is dynamic.
For example: if the images are located in ..\..\Pictures\*.jpg and I have a inventory record # associated with that photograph, can i link to it?
example: assume the hyperlink is in a cell on row 5 and the * references the value in Row 5, Column B
=hyperlink(..\..\Pictures\*.jpg,"photo")
The table this will go in is dynamic.