Can anyone help me with matching the onedrive hyperlink to the corresponding text file name in the first column? I can't make vlookup work as it will not bring across the working hyperlink - I believe because the hyperlink is assigned in the background, the cell itself just contains text. My idea was to use vlookup to ascertain the correct order of the hyperlinks (this is column B, eg. '1.1. Article 55 Notices' hyperlink is 18th in col C) and then re-sort column C to match that somehow, and thus not disrupt the hyperlinks by moving them. Is this possible?

excel Q.JPG