Is it possible to have multiple return ranges located in multiple forms with INDEX COLLECT?
For example, pulling from one other sheet will use the following:
=index(collect(return RANGE, criteria RANGE 1, criteria 1, ,1)
I am looking for the INDEX COLLECT function to return values from multiple sheets depending on if the criteria range matches my @row. This will be the only criteria I search on.
Help Article Resources
Check out the Formula Handbook template!