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