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

Ami Veltrie

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)))

Ami Veltrie

Please disregard this. I figured out it was a different issue, not the formula.

Ami Veltrie

Please disregard this. I figured out it was a different issue, not the formula.