indexmatch error

I have tried the formula in office and it works fine, but not in smartsheet, why is that? It doesn't show no match or any other error, but it doesn't show the correct result!!!!!!!

😥help me please!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!