I have a document that looks like this:

=IF(ISBLANK(HLOOKUP($B$4,$I:$IV,G3,0)),"",HLOOKUP( $B$4,$I:$IV,G3,0))

If the cell that is brought by using this formula has a "Hyperlink" in it, it
will not transfer the hyperlink with the lookup function.

I either want to have the hyperlink of that cell to be brought by using the
Hlookup function or any other option that allows me to click on the specific
cell that was brought to link me to another page on the worksheet.


Thank you in advance everyone.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1

How about:

=IF(ISERROR(HLOOKUP($B$4,$I:$IV,G3,0)),"",HYPERLIN K(HLOOKUP($B$4,$I:$IV,G3,0)))

Does this help?
Kostis Vezerides



instereo911 via OfficeKB.com wrote:
I have a document that looks like this:

=IF(ISBLANK(HLOOKUP($B$4,$I:$IV,G3,0)),"",HLOOKUP( $B$4,$I:$IV,G3,0))

If the cell that is brought by using this formula has a "Hyperlink" in it, it
will not transfer the hyperlink with the lookup function.

I either want to have the hyperlink of that cell to be brought by using the
Hlookup function or any other option that allows me to click on the specific
cell that was brought to link me to another page on the worksheet.


Thank you in advance everyone.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1

I tried the function out and it didn't work.

The error that it gives me is "Cannot open specific file".

My goal is to have the link that the cell that HLOOKUP gets to be
transitioned to the specific cell (where I input the function).



vezerid wrote:
How about:

=IF(ISERROR(HLOOKUP($B$4,$I:$IV,G3,0)),"",HYPERLI NK(HLOOKUP($B$4,$I:$IV,G3,0)))

Does this help?
Kostis Vezerides

I have a document that looks like this:

[quoted text clipped - 12 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1