EXCEL HYPERLINK: Link JPG in folder via hyperlink

I am trying to figure out if I can link a .jpg file with an Excel via hyperlink (or in another way).

Let me explain a bit more what I an trying to do:

Using Excel 2013:

1. I have a folder with +1000 images, named by EAN code.


2. I have an Excel file with all the EAN codes that I need an image of.

I would like to link each image with each cell in an extra column through a hyperlink.

Is this possible?

I have tried: =HYPERLINK("[Location pathway]\" & A1 & ".[filetype]","Click Here!")

I keep getting an error that it can't open the file.

Answer

Example below - I made a cell with the path and one with the file extension. Then I combined everything in another cell, like =path-cell & EAN-cell & file-type-cell. In D column I set the Hyperlink.

You can, of course, hide the rows and columns that you don't need.