Formula Index Match inconsistencies

Hello,

I have been using an Index match formula, however it doesn't always pull back the correct match or provides a no match however when validating the data, it is there.

Is there a better formula to use?

Here is what my current formula is in the cell:

=INDEX(reference sheet column),MATCH(@row in sheet,(reference sheet column),0)

As I mentioned some cells produce the correct name, some do not, and some have No Match. All cells are formatted the same.

Appreciate the help in advance.

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Are you able to provide screenshots of some that should be matching on but are not?

Suzanne Thompson

Hello,

Thank you for reaching out, I was able to find the solution with the index match feature.

Georgie

Hi @Suzanne Thompson,

Glad to hear you got this figured out! Would you be able to post the solution on this thread, to help any other Community members who come across the thread?

Thanks,
Georgie

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.