INDEX COLLECT getting "incorrect argument set" error

Robin Sugiura
Robin Sugiura โœญโœญโœญ

I am trying to pull one value from an archive sheet (source sheet) "MATCHID" when that value corresponds in the source sheet to the Candidate Name and Faculty Name listed in the target sheet.

=INDEX(COLLECT({MATCHID Archive}, {Faculty Name Archive}, [Faculty Name]@row, {Candidate Name Archive}, [Candidate Name]@row, 1))

Where {MATCHID Archive} is the single column of MATCHID in the archive sheet, {Faculty Name Archive} is the single column of Faculty Name in the archive sheet, and {Candidate Name Archive} is the single column of Candidate Name in the archive sheet. I have triple-checked the references; they are all a single column in the archive sheet corresponding to the relevant data.

Any ideas of where this is going wrong?

Best Answer

  • Mike TV
    Mike TV โœญโœญโœญโœญโœญโœญ
    edited 05/18/22 Answer โœ“

    @Robin Sugiura

    This works for me:

    =INDEX(COLLECT({MATCHID Column Sheet 1}, {Faculty Name Column Sheet 1}, [Faculty Name]@row, {Candidate Name Column Sheet 1}, [Candidate Name]@row), 1)

    You needed an ) after [Candidate Name]@row and then just a single ) at the end.

Answers

  • Mike TV
    Mike TV โœญโœญโœญโœญโœญโœญ
    edited 05/18/22 Answer โœ“

    @Robin Sugiura

    This works for me:

    =INDEX(COLLECT({MATCHID Column Sheet 1}, {Faculty Name Column Sheet 1}, [Faculty Name]@row, {Candidate Name Column Sheet 1}, [Candidate Name]@row), 1)

    You needed an ) after [Candidate Name]@row and then just a single ) at the end.

  • Robin Sugiura
    Robin Sugiura โœญโœญโœญ

    Brilliant! I knew it had to be some silly error, but for the life of me I couldn't find it.

    Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!