View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
suddengunfire suddengunfire is offline
external usenet poster
 
Posts: 10
Default Matching cells to files

Is it possible?

I have a folder, which contains files named "1", "2" & "3"

and then I have cells including names of those files, ie "1", "2" &
"3".

Is there a wonderful formula that can fast and easily match and
hyperlink the cell with the appropriate file in the folder?