Hyperlink from file based on cell value

[bencarey]

I would like to create hyperlink references to some jpeg files based on text values in cells. The jpeg's are located in a folder, let's say "C:\Data".
I have 2 columns in Excel. The first one will be the serial # for something I am collecting data for, say 001, 002, etc. This corresponds to the filename of the jpeg (001.jpeg, 002.jpeg).
In the second column, I would like to create a hyperlink to the jpeg file.
How would I create a hyperlink to C:\Data\"serial_number".jpeg based on the value of a cell containing "001"?

Thank you!

[SteveG]

Hi,

Try the HYPERLINK formula where your serial number is in A2.

=HYPERLINK("C:\Data\"&A2&".jpg",A2&".jpg")


HTH.

Steve

[bencarey]

That worked perfectly! Thank you!