VLOOKUP Macro?

[bjcasica]

I would like to develop a "macro" that converts the following excel formula into visual basic:
=HYPERLINK(cell address, "Go To File").
To further complicate this, rather than use an exact cell address, I want to use a VLOOKUP function, so the subroutine would include the following formula:
=HYPERLINK((VLOOKUP(ref cell, cell range,FALSE),"Go to File")

[Leith Ross]

Hello bjcasica,

Welcome to the Forum!

The best way to receive a fast and accurate solution to your problem is to attach a copy of your workbook along with your post. The more detail you can provide the better.

Sincerely,
Leith Ross