Say we have a lookup table in cols A & B with files and web sites:

1 http://www.cnn.com
2 file:///c:\temp\number.doc
3 http://www.fox.com


In E1 we put a number and in F1 we enter:

=HYPERLINK(VLOOKUP(E1,A1:B100,2,FALSE))

This will be a "hot" link to the file or site.
--
Gary''s Student - gsnu200805


"Gwynne" wrote:

I am trying to use the vlookup command (ie, =vlookup(a3,d3:d7,4) 4 linking to
a database that is hyperlinked to actual Word document forms. I want the
answer in the vlookup formula cell to be the hyperlinked document the user
can click on and fill out the apporpriate form. Any way to do that? Or, is
there a better way to do that?

Thanks,
Gwynne in Albuqueruqe