Sheet link

I posted before however, I don't think I was specific enough. I am sorry if I am wasting the time of anyone.

In my sheet, you will see three pages. On the "Search Notes" page in C5 I would like it to display the name of the user that posted the form. The reason I am doing it this way is so I can give people a public link to a form and then give them a private PIN that they can use in the form so I can make sure whoever is submitting the form is who they say they are according to the PIN they provided. I hope this makes sense however I don't think it will.


Use double VLOOKUP like:

=VLOOKUP(VLOOKUP(A2, 'Form Responses'!B2:D, 3, 0), 'Note Giver Names'!A2:B, 2, 0)



I don't know how to tag you user0. I made this post as a guest and I have made an account however it doesn't show as my question. I tried your suggestion and it does work however it only works for the first note, if you copy and paste the formula down it will just return the name of the first note matched instead of in order along with the query in A5.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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