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

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

Find more posts tagged with

Accepted answers

Ami Veltrie

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

All comments

Ami Veltrie

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.