Stumped on what formula to use

Kristen Christman

Hello! I struggle with formulas no matter how many times someone tries to show me how easy they can be. I hope someone here can help me figure out this solution, because I'm not sure what I'm doing wrong (or even if what I'm looking to do is possible).

I have an intake form I'm using to collect feedback from requesters "anonymously" on the job our team did with their request. I put anonymously in quotes because we know/can find (from information collected at the onset of a request that lives in another sheet) who submitted it in the first place. I find asking for feedback anonymously makes people feel like they can be more honest. I want to be able to see who submitted the feedback even though we didn't ask in the feedback form, so wanted to see if I can use a formula to pull in the requestors name that lives on one sheet into the feedback sheet (after their feedback has been submitted), using the request number as the value that need to "match" on both sheets to drop in the correct requestors name to that row/cell.

I tried using the MATCH formula, but I'm not getting any results, just errors. I tried to explain myself as best I could above, so fingers crossed someone can help! TYIA!

Paul Newcome

Youi would use an INDEX/MATCH like so:

=INDEX({Source Sheet Name Column}, MATCH([Request #]@row, {Source Sheet Request # Column}, 0))

Paul Newcome

Are you able to provide some screenshots with sample data for context?

Kristen Christman

I want this to match automatically though, every time a new feedback form is submitted and that MC # drops into the form. I figured a column formula would work here, I just don't know how to set it up. Thank you in advance, @Paul Newcome !

Paul Newcome

Youi would use an INDEX/MATCH like so:

=INDEX({Source Sheet Name Column}, MATCH([Request #]@row, {Source Sheet Request # Column}, 0))

Kristen Christman

Thank you, @Paul Newcome ! Yes! This worked! Now I know why @Sarah Val Valente says INDEX MATCH is life!

Sarah Val Valente

It is absolutely transformational for workflows ~ So curious to read more about how you're using it, @Kristen Christman. Talk soon!

Paul Newcome

Happy to help. 👍️

INDEX/MATCH > VLOOKUP

But if you think INDEX/MATCH is crazy, wait until you start getting into INDEX/COLLECT and/or nesting other functions within the INDEX function!