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.

Tags:

Answers

  • Scott Orsey
    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

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!