vlookups and hyperlinks

L

lmolle

I want to be able to enter a specified code on sheet 1 and have it go to the
hyperlink I have for that code on another sheet where I have the codes and
hyperlinks listed in a table format.
 
D

Dave Peterson

Something like

=hyperlink(vlookup(a1,sheet2!a:b,2,false))

might work for you.
 
Top