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), ""))

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)