Creating and IFERROR/INDEX/MATCH Formula for Exact Match


Greetings! I am seeking assistance to create an IFERROR/INDEX/MATCH formula that will look for an EXACT match of an Account ID between two Smartsheet. In Smartsheet 2 below I have an Iferror/Index/Match formula in the Status column that looks at the Account ID @row, searches the Account ID column in Smartsheet 2 and returns the associated status. The issue is that the Account IDs may include the same characters but diff cases. For example, the first two rows show the same Account ID in Smartsheet 1, but the last character is lower or upper case.

What is the trick in the Iferror/Index/Match formula to find the EXACT match?

Thank you,



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!