Index Collect not providing exact match

Ana Guilherme

Hello,

I have a cell that is using index collect, but the value is not the expected one.

I'm trying to find in a list of values the value that contains the sprint number.

However when I'm looking for Sprint 1, I get Sprint 16 or Sprint 17.

I guess when I have Sprint 20, something similar will happen.

Can someone help me on defining how to retrieve the exact match out of an index collect?

Thank you in advance

Paul Newcome

The problem is that "Sprint 1" and "Sprint 10" both contain "Sprint 1" as part of the text string. You will need to adjust the sprint numbers to include leading zeros on those that are less than 10.

Sprint 01

Sprint 02

Ana Guilherme

Thank you!

Paul Newcome

Are you able to provide the formula you are currently using as well as a screenshot of the source data?

Ana Guilherme

Hello @Paul Newcome

Sure! (I should have done that in the initial post, apologies :( )

Attached the picture, where I have the column Sprint Nickname and I wish to find that cell value in a list where I have my sprints names.

Thank you in advance.

Paul Newcome

The problem is that "Sprint 1" and "Sprint 10" both contain "Sprint 1" as part of the text string. You will need to adjust the sprint numbers to include leading zeros on those that are less than 10.

Sprint 01

Sprint 02

Ana Guilherme

Thank you!

Paul Newcome

Happy to help. 👍️