View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toni-Ann Mistretta
 
Posts: n/a
Default Vlookup returning Hyperlinks

This actually was semi helpful to my problem. Is there a way to do this with
embedded hyperlinks?



"Lotus123" wrote:


You might try the HYPERLINK function on the vlookup...for example:

=HYPERLINK(VLOOKUP(A1,D1:E100,2,FALSE),"Click here for more customer
information")


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=480855