Why does my INDEX(MATCH()) column formula return #NO MATCH for some values?

I have a simple formula (below) that references another sheet matching the value @row on the destination sheet. This is a column formula in the [P6Description] column.

=INDEX({Source Sheet - Description}, MATCH([P6Number]@row, {Source Sheet - Project Number}))

Why am I getting #NO MATCH for the project numbers starting with "C" but the rest of the "PRJ…" projects match source sheet descriptions perfectly?

Find more posts tagged with

Accepted answers

Paul Newcome

Try specifying an exact match in the MATCH function.

=INDEX({Range}, MATCH([Column Name]@row, {Range}, 0))

All comments

Paul Newcome

Try specifying an exact match in the MATCH function.

=INDEX({Range}, MATCH([Column Name]@row, {Range}, 0))

dylanchaney

… so easy I overlooked it. But where's the fun in that?? 😂 Thank you @Paul Newcome

Paul Newcome

Happy to help. 👍️

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.