Index/Match Formula Referencing Contact Columns Providing Wrong Values

I need help with a formula. Since there is no way to cross-check against a group in a sheet, I have created a sheet listing all users of a particular group and am trying to use a cross-sheet reference formula in my intake sheet to be able to identify when a requestor is not already in the group so that I can add them for sharing purposes.

Before I get too far into this formula, I am trying to start with a simple Index/Match but it is returning the wrong value. Help!

=INDEX({DAM Group Management | DAM Partners}, MATCH([Requestor Email]@row, {DAM Group Management | DAM Partners}))

Find more posts tagged with

Contacts

Formulas

INDEX

MATCH

Accepted answers

All comments

Shimanta Roy

I guess, your references are not correct. In your given formula, you have used {DAM Group Management | DAM Partners} in both the Index range and Match range, which seems incorrect. Could you share the more elaborately which columns are you referring for which purpose?

Chelsea.McCulley

It is a sheet with a single contact column. I am trying to have the formula in a different sheet look for a value in that column and if it finds it, return it. My ultimate goal is to reference a contact in sheet a, look through the contact list in sheet b, and if the contact is not there then alert me. If there is a better way to do this, I am all ears.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.