INDEX/COLLECT

L. Barrett

Good afternoon,

I am used to INDEX/MATCH but this time I need to match two columns and then pull the information in a third column.

Here is where I currently am:

=INDEX(COLLECT({Meeting Planner}, {Meeting ID}, [Meeting ID]@row, {Vendor Type}, "A/V"))

I want to pull the information in Meeting Planner from Sheet 2 when both the Meeting ID on Sheet 2 matches Sheet 1 and when the Vendor Type on Sheet 2 is A/V (or Security, Other, Court Reporter).

I know this is probably a simple thing to do, I just cannot get it to work.

Thanks,

Laura

Paul Newcome

You are missing which "row" to pull from the array created (on the back-end) by the COLLECT function. Your formula should end like this:

=INDEX(COLLECT(……………….), 1)

Paul Newcome

You are missing which "row" to pull from the array created (on the back-end) by the COLLECT function. Your formula should end like this:

=INDEX(COLLECT(……………….), 1)

L. Barrett

Paul,

Thanks so much. I figured it was something little but could not tell what was missing.

Paul Newcome

Happy to help. 👍️