INDEX/MATCH is not pulling one value



I'm completely stumped by this. I have a column formula in Column A in Sheet X with INDEX AND MATCH. It is pulling every value from Sheet Y perfectly fine except for one:

I've double checked on both Sheet X and Sheet Y that there are no extra spaces or other weirdness in the company name on either sheet. They match exactly. I also deleted from and reinserted the row into Sheet Y. I changed from column formula back to cell formula and back again. And now I'm at the end of troubleshooting ideas. Does anyone have any idea what might be happening here?

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!