Hyperlink with Vlookup

[HoneyBear]

Hi,

I am having some trouble with setting up a hyperlink with a Vlookup. I want to set up a Hyperlink, returning the description of the code as well as acting as the hyperlink.

I have set this up a table with the ability to scroll - developer - add scroll bar to table,

So when I scroll down on the table, the cell would adjust and in turn the description of the code will change and by clicking on the decription the hyperlink would take you to the tab of that account.

I am using the below, the V lookup is working however the hyperlink is saying "Cannot open specific file"


[TABLE="width: 500"]
<tbody>[TR]
[TD]=OFFSET(C3,$K$2,0)[/TD]
[TD]=HYPERLINK(VLOOKUP(M4,Dataset1,2,0))[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

If anyone can point out what I am doing wrong, that would be great -

Thanks in advance,
HB

 

[HoneyBear]

Ah.. sorted it with -

=HYPERLINK("#"&ADDRESS(1,1,,,M4),N4)