Using Index Collect formula when there are multiple matches in the source sheet. (#Invalid Value)

Hello,

My goal with using INDEX(COLLECT)) was to obtain information based on 3 different criteria, but in my source sheet there are multiple matches for the three criteria specified.

What do I need to add to the Index, Collect formula to overcome this or do I need to use a different formula combination?

Below is the formula:

=INDEX(COLLECT({Reviewer}, {Product}, [Product Name]@row, {Review Type}, [Review Type]@row, {Round}, [Round #]@row), 1)

Thanks,

Find more posts tagged with

Formulas

Project Management

Enhancement Request

Accepted answers

SebastienD

The criteria 1 row was missing an underscore that was present in the source sheet column so that's what the error was from, seems to be working now.

All comments

SebastienD

The criteria 1 row was missing an underscore that was present in the source sheet column so that's what the error was from, seems to be working now.

Genevieve P.

Hi @SebastienD

I'm glad you got it working! Thanks for posting your solution.

Cheers,

Genevieve

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.