INDEX MATCH #INCORRECT ARGUMENT SET

Jennifer Lindquist

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

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

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. 👍️