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:
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