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.
Best Answer
-
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)
Answers
-
Are you able to provide some screenshots for reference?
-
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
-
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)
-
Solved.
Thank you so much Paul, I am a huge fan!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!