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

Pam Grant

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)

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

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. 🙂