Insert an automatic image hyperlink on a column with reference to another column

New Contributor
Hi All
I have a problem with an Excel formula that I can't find. I would like to link images that are on my computer to a column of my Excel sheet, which has the same appointment as the member IDs of another column.
And I would like to do it automatically. I have shared with you the file as it is. Column E corresponds to member IDs and column J corresponds to the images I would like to have linked that have the same names as member IDs.
Please assist and help me to resolve this problem.
2 Replies


Let's say the image files are .jpg files in C:\Images.

In J2:


In French:


Fill down.