VLOOKUP Multiple Matches
Answers
-
COLLECT is basically like adding an IF to any function.
=COLLECT(range_to_collect, criteria_range_1, criteria_1, criteria_range_2, criteria_2, ............................)
-
Paul, I understand the IF function very well, but the COLLECT seems different. Everyone who defines it uses the word collect in their definition, or repeats the syntax. Is there a plain English description of this function, like "looks at the within the stated range, compares them to the criteria listed, and returns the largest value...", or something like this?
-
It pulls together ALL values from the first range based on the range/criteria sets.
When you nest it inside of another function, that function will only evaluate the data that was pulled by the COLLECT function.
Think of it almost as a JOIN function but on the back-end and with the ability to add criteria, and then the main function evaluates the "text string".
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!