Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 1
Default VLookup result to be an active hyperlink

Gents,
I wan tyour help on this one. I have 2 sheets on my workbook and on the
first sheet (that I called sheet1) I have a table with a column
containing hyperlinks to an outside focuments.

On the second sheet (sheet2) I use VLookup on a cell and the result is
coming from the column containing hyperlinks. As you may know the
hyperlink I'm receiving on the second sheet isn't active as it's just a
result of a VLookup function. However on sheet1 the hyperlinks are
active.

How to do to make the hyperlinks resulting form my VLookup function
active (a cell on sheet2) as it is on sheet1.

The question should may be "Is it possible to do that?"

Xavier Lopes

  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 4
Default VLookup result to be an active hyperlink

Hey Kapploz

You can try the hyperlink function. The syntax would look like,

=HYPERLINK(VLOOKUP(C6,Sheet2!$A$4:$D$6,4,FALSE))

Rgds
Joham

Kapplox wrote:
Gents,
I wan tyour help on this one. I have 2 sheets on my workbook and on the
first sheet (that I called sheet1) I have a table with a column
containing hyperlinks to an outside focuments.

On the second sheet (sheet2) I use VLookup on a cell and the result is
coming from the column containing hyperlinks. As you may know the
hyperlink I'm receiving on the second sheet isn't active as it's just a
result of a VLookup function. However on sheet1 the hyperlinks are
active.

How to do to make the hyperlinks resulting form my VLookup function
active (a cell on sheet2) as it is on sheet1.

The question should may be "Is it possible to do that?"

Xavier Lopes


--
Message posted via http://www.officekb.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion of Numercials to Figure JAGANNATH Excel Worksheet Functions 1 April 4th 06 04:12 PM
Displays the number in text. (One thousand two hundred thirty four Ashish Patel Excel Worksheet Functions 1 March 20th 06 10:27 PM
how to use spellnumber formula Aarif Excel Worksheet Functions 3 February 27th 06 05:36 PM
spell number JAWAD CHOHAN Excel Worksheet Functions 1 December 12th 05 06:58 PM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 08:32 PM


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"