Index/Match Formula

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!

Find more posts tagged with

Formulas

INDEX

MATCH

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.