jeudi 27 juillet 2017

hyperlink in excel if file exists in folder

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