Index Match Issues - #NO MATCH

atewari1

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.

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