Something like:

=HYPERLINK("file:///c:\" & A1 & ".xls","go there")
and copy down
--
Gary''s Student - gsnu2007i


"suddengunfire" wrote:

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?