excelmatchsumifsexact-matchexcel-match

Excel MATCH and SUMIF Formula Not Matching Wxact Matches

I have a sheet with exact values (verified by =a2=b2 returning true).

However, =match(a2,b2,0) returns #N/A for some values, but not all.

All cells are formatted the same (I've tried General, Text, Number, etc.), and I have no idea where to go from here.

I don't know if I can upload my test workbook here so here's an image:

image

Solution

  • Maybe run a quick macro on the relevant cells in columns A and B:

    Sub Clean_Up()

For Each r In Range("A2:B8")
    r.Value = Val(r.Value)
Next r

End Sub

    Adjust range (A2:B8 here) to suit.

    Regards