How do I write an Index/Match formula that pulls an EXACT match?

Ami Veltrie
Ami Veltrie ✭✭✭✭✭✭
edited 09/19/23 in Formulas and Functions

I'm pulling data into a sheet using a cross sheet Index/Match. However the formula is stopping at the first 'match' (from source sheet) and not finding the exact match. Therefore resulting in the wrong "Avi ID".

For example:

Account Name #1: Acme, Inc

Account Name #2: Acme, Inc. - Canada

=IF([Account Name]@row = "", "", INDEX({SF Account and Avi Customer Names-Avi ID}, MATCH([Account Name]@row, {SF Account and Avi Customer Names-AccountNameSF}, 0)))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!