ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
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.
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.