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.
image.png
2 Replies

@TheOTeam 

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

In J2:

=HYPERLINK("C:\Images\"&E2&".jpg")

In French:

=LIEN_HYPERTEXTE("C:\Images\"&E2&".jpg")

Fill down.