Index/Match Formula

cking91

Hello, I am needing advice on using this cross sheet formula to produce values in a cell. I have one sheet that is populated by responses to a form. I have another sheet with a list of people and their contact details. As the form responses come in to the sheet, I would like their answers to also populate on the other sheet (master list of people). I want to do this by matching their email addresses. How can I properly use this formula to accomplish this? Or is there another option?

=INDEX({TEST Stay Interview Range 1}, MATCH([Work Email]@row, {TEST Stay Interview Range 2}))

I am using this formula but it populates the most recent response into every cell with the formula instead of matching the emails. Any help is appreciated!

Darren Mullen

@cking91

Try adding the "0" condition to match to ensure an exact match:

=INDEX({TEST Stay Interview Range 1}, MATCH([Work Email]@row, {TEST Stay Interview Range 2},0))

cking91

Hi Darren, I did try this and it returns "NO MATCH"

Darren Mullen

Then I'ad have to see the data your matching and the range that you are trying to match it to.