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)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!