Hi all,
Could you please let me know what's wrong with the formula below. I am using the HYPERLINK function together with some helper columns to complete a link to another worksheet (with a name with space and a dash symbol), but I end up getting an invalid reference error. Thanks in advance!
Regards,
Zed
Could you please let me know what's wrong with the formula below. I am using the HYPERLINK function together with some helper columns to complete a link to another worksheet (with a name with space and a dash symbol), but I end up getting an invalid reference error. Thanks in advance!
A | B | C | D | |
---|---|---|---|---|
1 | Name of the worksheet | Cell Reference (specific cell in the worksheet I want to be selected when the link on the last column is clicked) | Friendly Name (part of the HYPERLINK function) | HYPERLINK formula |
2 | PS - X1 | Q10 | Item 1 | =HYPERLINK("#"&$A2&"!"&$B2,$C2) |
Regards,
Zed