INDEX/COLLECT

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

Find more posts tagged with

Accepted answers

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)

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.