INDEX COLLECT getting "incorrect argument set" error
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
-
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
-
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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!