Go to and play

  • Thread starter instereo911 via OfficeKB.com
  • Start date
I

instereo911 via OfficeKB.com

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.
 
V

vezerid

How about:

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

Does this help?
Kostis Vezerides
 
I

instereo911 via OfficeKB.com

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).


How about:

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

Does this help?
Kostis Vezerides
I have a document that looks like this:
Click to expand...
[quoted text clipped - 12 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200610/1
Click to expand...
Click to expand...
 
Top