Index match returns a wrong value

MPath

https://community.smartsheet.com/discussion/comment/418908#Comment_418908

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! :)