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-com
ffice
ffice" /><o
></o
>
<o
> </o
>
Thank you,<o
></o
>
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-com
<o
Thank you,<o