hyperlinking to a local file based on cell value

[MurphDog]

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.

 

[Dave87]

Can you take a screenshot, im struggling to understand the layout of your page

this might do but Im not sure about the references or what information you have on row 5
=HYPERLINK(B5&A5,A5)

 

[MurphDog]

I apologize for the delay, been distracted, but that looks like it will work. Thank you!