Unable to hyperlink vlookup between sheets

[danbrighton76]

Hi,

I have a problem which I need to try and sort out for work. Please can someone help. The current way I have it setup seams to work on excel 2010 at home, but at work we have excel 2000 and it does not appear to work.

I have data in sheet 1 and on one of these cells you would enter a reason code. This would then populate the cell to the right with an hyperlink. This helps the hyperlink sending you to a specific file depending on the reason code.

In sheet 3 I have all the reason codes and next to these I have the actual inserted hyperlinks

Back to sheet one, the cell which populates the hyperlink when you select a reason code works using the following formula.

=HYPERLINK(VLOOKUP(V4,Sheet3!A37:B57,2,FALSE))

At first I was not using the HYPERLINK function and just getting it to vlookup the data in sheet one, which as the actual hyperlinks. However doing it this way only copied the text over to sheet 1 from sheet 3 and not the hyperlink.

By including the hyperlink function it carries over the hyperlink as well.

The problem is this, the actual hyperlink on sheet 3 obviously works fine, however even though in sheet one the vlookup does bring over the correct hyperlink and the hyperlink is in sheet 1. When I hit the hyperlink error message "file cannot be found" appears.

I am sure my spreadsheet at home is setup exactly the same as mine at work so think it is an issue with excel 2000. Unfortunately cannot send my spreadsheet to work or vice a versa because of data protection issues, but I think I am using the same process anyway. Just does not seem to work at work on excel 2000.

Can anyone please help.

Thanks
Dan

 

[salmerin]

Hi,

I have a problem which I need to try and sort out for work. Please can someone help. The current way I have it setup seams to work on excel 2010 at home, but at work we have excel 2000 and it does not appear to work.

I have data in sheet 1 and on one of these cells you would enter a reason code. This would then populate the cell to the right with an hyperlink. This helps the hyperlink sending you to a specific file depending on the reason code.

In sheet 3 I have all the reason codes and next to these I have the actual inserted hyperlinks

Back to sheet one, the cell which populates the hyperlink when you select a reason code works using the following formula.

=HYPERLINK(VLOOKUP(V4,Sheet3!A37:B57,2,FALSE))

At first I was not using the HYPERLINK function and just getting it to vlookup the data in sheet one, which as the actual hyperlinks. However doing it this way only copied the text over to sheet 1 from sheet 3 and not the hyperlink.

By including the hyperlink function it carries over the hyperlink as well.

The problem is this, the actual hyperlink on sheet 3 obviously works fine, however even though in sheet one the vlookup does bring over the correct hyperlink and the hyperlink is in sheet 1. When I hit the hyperlink error message "file cannot be found" appears.

I am sure my spreadsheet at home is setup exactly the same as mine at work so think it is an issue with excel 2000. Unfortunately cannot send my spreadsheet to work or vice a versa because of data protection issues, but I think I am using the same process anyway. Just does not seem to work at work on excel 2000.

Can anyone please help.

Thanks
Dan

Did you get an answer to your question? I am running into the same problem, exactly the same one but I have not found a solution to this.

My current thread is:

http://www.mrexcel.com/forum/showthread.php?t=581738&highlight=hyperlink+vlookup

If you did get it fixed then could you please PM me or post it on my thread too for everyone else to see the solution?

Thanks