Index match returns a wrong value

MPath

AbrinaLL

Feb 8, 2024

I had a problem when using INDEX and MATCH function. My function wrapped in an IFERROR was producing a number but not the right one. I figured out that Smartsheet's has default values for optional Syntax; in this case it was default to 1 for sort acceding, and 0 for not sorted. Since I didn't add a ,0 to my MATCH function at the end like I did for the INDEX when trying to fix my problem originally, the function still displayed the wrong numbers until I added the , 0), 0)

=IFERROR(INDEX({Weekly Bin Count}, MATCH([Store Number]@row, {Order to Store}, 0), 0), "No Order")

Thank you! This worked out for me. Though I don't understand why I have to add a 0 to the Match function, but that's my noobishness. I took Paul's comment aboard too.

Paul Newcome

@MPath The zero in the INDEX function isn't needed. It is the zero in the MATCH function that will make a difference. That piece of the MATCH function is what determines whether you are looking for an exact match (zero) or a close match (sorted one way or the other base don positive or negative one).

Kadie Butterfield

@Kayla Q Thanks for leaving this comment!! Saved me a huge headache because I had done the exact same thing as you with this formula! :)