Index/Match works on all rows except a couple

mskates696

Hello,

I have a strange issue where my INDEX/MATCH formula seems to work on all rows except, for example, this one below.

This is a listing of requests for a client. I've hidden certain columns for privacy, but the hidden columns are not used at all in the formula. Every request has a unique ID (primary column). There are certain requests that are duplicates. For example. request #182 is a duplicate request of request #176. They are denoted as such because I needed a way to filter for only unique requests.

What is supposed to happen is that the Repeat Status column should match the Status of the unique request. So here, Repeat Status for Request #182 should say Not Started to match Request #176. There is a column formula for Repeat Status that goes as such:

=INDEX(Status:Status, MATCH([Repeat Request]@row, [Unique ID]:[Unique ID]))

Am I missing something here? Or do I need to contact customer support? I've verified that there is only ONE "176" in the Unique ID column.

Kelly Moore

Hey @mskates696

See if this fixes the issue

=INDEX(Status:Status, MATCH([Repeat Request]@row, [Unique ID]:[Unique ID],0))

I added the search type to your formula.

Kelly

https://help.smartsheet.com/function/match

Kelly Moore

Hey @mskates696

See if this fixes the issue

=INDEX(Status:Status, MATCH([Repeat Request]@row, [Unique ID]:[Unique ID],0))

I added the search type to your formula.

Kelly

https://help.smartsheet.com/function/match

mskates696

That did the trick, thanks! @Kelly Moore