Broken VLOOKUP hyperlinks

[ollyhughes1982]

Hi all.

I was wonderiing if someone might be able to help with this issue please?

I have formulas in my spreadsheet (see example below), that pull a link from another worksheet. I thought these were working, as they display correctly, but if you try and click the link it doesn't work.

=IFERROR(HYPERLINK(VLOOKUP(A4,'Miscellaneous Data - P & C p'!$B$3:$R$5002,17,FALSE)),"")

Am I missing something from my formula?

The error I get is in the image.

Thanks.

 

[Coding4Fun]

From your screenshot it looks like your path is invalid

This should be
/Users/Olly/Desktop/pr_WORKING/www.parkfun.org.uk/aberdeen

This
C:/Users/Olly/Desktop/pr_WORKING/www.parkfun.org.uk/aberdeen

Unless your actually trying to have the hyperlink open a web page vs a file? Looks like you maybe trying to navigate to <>parkfun.org.uk/aberdeen?<>

 

[ollyhughes1982]

Yes, I’m trying to open the webpage: www.parkrun.org.uk/aberdeen

 

[ollyhughes1982]

The www.parkrun.org.uk/aberdeen link is what is in the source worksheet, and the address I want it to open. I don’t know where the the file path bit is even coming from

 

[Fluff]

What happens if you click the open button?

 

[ollyhughes1982]

I get 'Cannot open the specified file.'

 

[Fluff]

In that case use the Evaluate Formula button on the formula tab to evaluate the formula & see exactly what it's returning.

 

[ollyhughes1982]

I can’t see this on Mac. Is it called something else, possibly?

 

[ollyhughes1982]

I have just checked and it isn’t available on mac

 

[Fluff]

In that case I don't know how to check what is happening.