INDEX / MATCH / CONTAINS Assistance

Looking for your help, the below formula works for the moment:

=IFERROR(INDEX({SFDC Opps for Renewals Range 1}, MATCH(SFOP@row , {SFDC Opps for Renewals Range 2}, 0)), "No Match Found")

However the column above actually contains multiple SFOPs and so I think I need to add a CONTAIN element to the formula so when SFOP column contains an SFOP that matches with an SFOP on Range 2?

Thanks

Find more posts tagged with

INDEX

MATCH

contains

Accepted answers

All comments

Adam Murphy

If you want to MATCH against multiple criteria you will need to use COLLECT instead. INDEX/COLLECT should work for your use case. Hope this helps!

Paul Newcome

Are you able to provide some screenshots (sample data is fine) for context?

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.