My problem is similar to the original poster, Shannon, issue. I have two
drop down menues for the ultimate use to select. There are 13 possible
results once the user selects from both menues, of which only one is a Web
Address.

In the table where the results reside I have formatted the Web Address
column so that the hyperlinks work there but that tab is to be hidden.

Can this be done? I have several thousand users depending on me for this
spreadsheet.

Thanks

Michael


"Toni-Ann Mistretta" wrote:

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