Hi have two columns with ID´s and i want to compare them see, if an Id number has a match or a mismatch in the other column.
What kind of formula de you recomend to do this?
I used Vlookup: =VLOOKUP([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1; false)
and Match; =MATCH([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1)
But i only recieved #NO MATCH and thats wrong cause i know i have some matches.