Index Match Issues - #NO MATCH

I have 2 sheets. In sheet 1, I am trying to output the project names based on matching PO# values between sheets 1 and 2, sheet 2 has corresponding project names. I am getting a #NO MATCH error.

My first thought is that this is happening because there are multiple lines in sheet 2 with that PO# and Project names.

My formula is =INDEX({2024 PDS Project}, MATCH([PO#]@row, {2024 PDS PO Value Only (Finance)}))

Is there a way to circumvent this error? It seems to be the case for multiple PO#s across several projects.

Find more posts tagged with

Formulas

Accepted answers

All comments

Scott Orsey

Hi... first thing I'd try is setting the third argument in the MATCH() function to 0 to look for an exact match. I don't think there would be any issue with more than one match. It would just return the first it finds.

Hope this helps.

Be well

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