INDEX MATCH #INCORRECT ARGUMENT SET

I'm attempting to pull data from secondary sheets to the primary sheets using this formula:

=INDEX({Supervisor Alert - 1st Response}, MATCH(Name@row, {Supervisor Alert - 1st Name}, Created@row, {Supervisor Alert - 1st Date}, 0))

Formula result should be:

Talked with Op, talking with Maint about proper settings to train/post at line.

What am I missing?

Primary sheet:

Created column is created date

Secondary sheet:

Date column is created date

Find more posts tagged with

Accepted answers

Jennifer Lindquist

Thank you!

Changed to:

=IFERROR(INDEX(COLLECT({Supervisor Alert - 1st Response}, {Supervisor Alert - 1st Name}, Name@row, {Supervisor Alert - 1st Date}, Created@row), 1), "")

Formula works! 😀

All comments

Paul Newcome

MATCH only allows for a match in a single column. If you need to match across multiple columns (name and date for example), you would use an INDEX/COLLECT.

=INDEX(COLLECT({Range To Pull From}, {1st Criteria Range}, 1st criteria, {2nd Criteria Range}, 2nd criteria), 1)

Jennifer Lindquist

Thank you!

Changed to:

=IFERROR(INDEX(COLLECT({Supervisor Alert - 1st Response}, {Supervisor Alert - 1st Name}, Name@row, {Supervisor Alert - 1st Date}, Created@row), 1), "")

Formula works! 😀

Paul Newcome

Happy to help. 👍️

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.