How can I use Index Match Match

sstelmack

I am trying to use index match to pull a contact name from the last person who worked on the project.

This one works which is on the same page but I need a version from a different page

=INDEX([ASSIGNED ENGINEER]@row, MATCH([JOB NAME]@row, ""), MATCH([JOB NAME]@row, ""))

Im following the same rules index the Range of people and match the same Columns to pull any name that is there

=INDEX({APN/DFA COMPLETED Range 3}, MATCH({APN/DFA COMPLETED Range 2}, ""), MATCH({APN/DFA COMPLETED Range 2}), "")

I also tried this using the job name on the page im currently on

=INDEX({APN/DFA COMPLETED Range 3}, MATCH({APN/DFA COMPLETED Range 2}, ""), MATCH([JOB NAME]@row), ""))

Find more posts tagged with

Formulas

Accepted answers

All comments

heyjay

You are missing the last Match arguement, zero for exact match.

…MATCH([JOB NAME]@row, "",0)…

sstelmack

So like this

=INDEX({APN/DFA COMPLETED Range 3}, MATCH({APN/DFA COMPLETED Range 2{APN/DFA COMPLETED Range 4}}, ""), MATCH([JOB NAME]@row), "", 0 ))

that does not work

heyjay

Paul N made a suggestion when matching multiple criteria. Use Index Collect instead:

https://community.smartsheet.com/discussion/100275/how-to-index-match

sstelmack

I did try that as well,I want it to pull a name from the same JOB name

=INDEX(COLLECT([ASSIGNED ENGINEER]@row, [JOB NAME]@row, "", [JOB NAME]@row, ""), 1)

=INDEX(COLLECT({APN/DFA COMPLETED Range 3}, [JOB NAME]@row, "", {APN/DFA COMPLETED Range 4,""}), 1)

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.