I want to create a hyperlink if and only if a file exists with a specific name in my folder. Otherwise I want the cell to remain blank. I have a folder with very specific file names that I want excel to search through and return the hyperlink if the name is found. I was thinking of the following code but can't get it to work:
=IF(find("8197837", foldername, "8197837"), hyperlink(folder name, 8197837), "")
Aucun commentaire:
Enregistrer un commentaire