INDEX/MATCH find some but not all. Mixed numbers and letters in MATCH fields

Any ideas why I'm getting no results for 305WI001 and 209WI007?

Here is my formula:

=INDEX({DQDs in Review Doc Group}, MATCH([DQD No.]@row, {DQDs in Review DQD No.}))

It seems the DQD No. with a "WI" returns no results but the rest do.

I've checked my source data and there is a Document Group designated for both 305WI001 and 209WI007.

Both sheet columns are formatted the same in the two sheets. ("Text/Number" for DQD No. and "Multi-Select" for Document Group)

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Pam Grant

Try adding a zero at the end of your Match function - this will tell it that your list in the other sheet is not in any order:

=INDEX({DQDs in Review Doc Group}, MATCH([DQD No.]@row, {DQDs in Review DQD No.}, 0))

Let me know if that made a difference!

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Pam Grant

Try adding a zero at the end of your Match function - this will tell it that your list in the other sheet is not in any order:

=INDEX({DQDs in Review Doc Group}, MATCH([DQD No.]@row, {DQDs in Review DQD No.}, 0))

Let me know if that made a difference!

Cheers,

Genevieve

Pam Grant

Thank you @Genevieve P. ! This completely resolved my problem!

Thank you for telling me WHY to add the ",0" at the end of my formula!

Genevieve P.

I'm so glad this worked for you, @Pam Grant! One small detail can make all the difference. 🙂

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.