I know that you can use the Hyperlink function to insert a hyperlink in a cell. What I need to know is how to make the results of another function that returns the hyperlink work in that function.
For instance, I can lookup the URL by using the VLOOKUP function As in this example, but I am not getting something quite right (quotes, parenthesis, etc.) to make it work.
=hyperlink((=VLOOKUP([Task '#],BigTaskOrder[[#All],[Task Number]:[Travel Revenue]],58,FALSE)),"Link to Task"))