Help with Conditional Index Match

MichaelO1

Hello,

1. I have a sheet titled Copy/Paste Data with a column that has multiple text values.
2. 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.

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)

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