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?

Matching cells to files
 

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?

Matching cells to files
 

On May 30, 4:47*pm, Gary''s Student
wrote:

=HYPERLINK("file:///c:\" & A1 & ".xls","go there")
and copy down

what a wonderful formula! Thanks!