Forum Discussion
Insert an automatic image hyperlink on a column with reference to another column
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.
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.
HansVogelaar thank's so much! It work
