Here's a sample form:

And here's the linked spreadsheet:

I've created an extra sheet named Comments to draw data from the Source sheet. The data on the second sheet should be exactly like the first sheet, except column B of the Comments sheet: I'd like the usernames to be hyperlinks using the following URL:
As a result, for the username @johnDoe on sheet 1, I should have the following on sheet 2:

1 Answer 1


You can do this very easily with a literal array and array formula:


The first part creates the header, the below it it pulls in the first column, then uses and if check to only hyperlink fields in column B that have text in it, then pulls column C.

This way you only enter the formula once at the top and never have to edit it again

enter image description here

  • I inserted the above formula in the Comments sheet A1 with no changes, but I got an error message. I don't know why, but it doesn't work for me!
    – Mori
    Commented Jul 18, 2017 at 8:07
  • Thanks for the answer! It does exactly what I want. I just wish there were a simpler formula to handle it.
    – Mori
    Commented Jul 18, 2017 at 8:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.