Creating and IFERROR/INDEX/MATCH Formula for Exact Match

John Crick

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,

John

Paul Newcome

You would want an INDEX/COLLECT instead so that you can incorporate the case sensitive FIND function.

=IFERROR(INDEX(COLLECT({Range To Pull Over}, {Account ID}, FIND([Account ID]@row, @cell)> 0), 1), "")

Paul Newcome

You would want an INDEX/COLLECT instead so that you can incorporate the case sensitive FIND function.

=IFERROR(INDEX(COLLECT({Range To Pull Over}, {Account ID}, FIND([Account ID]@row, @cell)> 0), 1), "")

John Crick

That did the trick! Thank you!