Help with Conditional Index Match

Hello,

I have a sheet titled Copy/Paste Data with a column that has multiple text values.
I have another sheet titled 23-24 Status.

I am trying to conduct an index match on sheet titled Copy/Paste Data when a specific column within this sheet contain the text SNP but keep getting #UNPARSEABLE error.

=IF({Copy/Paste Data Range 1}) = "SNP", INDEX({Copy/Paste Data Range 2}, MATCH(CEID@row, {Copy/Paste Data Range 3}, 0))

All assistance is greatly appreciated.

Find more posts tagged with

Conditional Formatting

Accepted answers

Paul Newcome

It looks like you are going to need an INDEX/COLLECT instead. Try this:

=INDEX(COLLECT({Copy/Paste Data Range 2}, {Copy/Paste Data Range 3}, @cell = CEID@row, {Copy/Paste Data Range 1}, @cell = "SNP"), 1)

All comments

Paul Newcome

Are you able to provide some screenshots for reference?

MichaelO1

Index Match will only on rows that contain the word "SNP" on the Copy/Paste Data sheet.

Copy/Paste Data Range 1 = Program column

Copy/Paste Data Range 2 = Review column (far right)

Copy/Paste Data Range 3 = CEID column

Paul Newcome

It looks like you are going to need an INDEX/COLLECT instead. Try this:

=INDEX(COLLECT({Copy/Paste Data Range 2}, {Copy/Paste Data Range 3}, @cell = CEID@row, {Copy/Paste Data Range 1}, @cell = "SNP"), 1)

MichaelO1

Solved.

Thank you so much Paul, I am a huge fan!

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