why not just vlookup on the seperate sheet?
--
paul

remove nospam for email addy!



"scott" wrote:

Can a hyperlink perform a VLOOKUP?

By clicking a hyperlink, I want to be able to go to a form in a different
sheet and have all the associated information come with.

I have it so the hyperlink goes to the form on a different sheet, however, I
still have to fill in the RGA # (vlookup ref cell) to fill in the blanks. I
wonder if I could skip this step. Could I do this by just clicking the
hyperlink?

Thanks for your help
-Scott