Vlookup Using With Hyperlink

[sanam]

hello all,

I have 2 sheets. In 2<SUP>nd</SUP> sheet I have some hyperlink cells and when I was using vlookup in sheet 1 hyperlink don’t show. Let’s says in sheet 2, cell A1 “alpha” cell B1 “delta” with hyperlink and I will write code in sheet 1, cell A2 “=VLOOKUP (A1, Sheet2! A: B, 2, 0)” so when I wrote in sheet 1, cell A2 alpha it should be show in delta but hyperlink in doesn’t work? Any idea and hope some one understand my problem. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Thank you,<o></o>

 

[barry houdini]

Try using the VLOOKUP inside HYPERLINK function, i.e.

=HYPERLINK(VLOOKUP(A1,Sheet2!A:B,2,0),A1)

 

[sanam]

Try using the VLOOKUP inside HYPERLINK function, i.e.

=HYPERLINK(VLOOKUP(A1,Sheet2!A:B,2,0),A1)

Thank for quick reply , there have error “the address of this site is not valid. Check the address and try again”. I checked the hyperlink is working in sheet2. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Excel_Assis]

Hi Barry been reading this post but do not understand what is entered where. Could I ask you to explain please.