What do I need to enter for my 2nd criterion range in an index-collect formula?

Andrew Ryback

Hi all,

I'm looking for help with an index-collect formula.

I want to collect the venue name from an existing sheet using the project name as my criterion. The problem I'm running into is I'm not sure what value to enter for the second criterion range.

Below is the formula I currently have, which I know is incorrect.

Any suggestions?

=INDEX(COLLECT({VENUE}, {PROJECT}, PROJECT@row, ""), 1)

Andrew Ryback

SCRATCH THAT! I figured it out.

Andrew Ryback

SCRATCH THAT! I figured it out.