COMPARE COLUMNS

08/07/20
Answered - Pending Review

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.

Popular Tags:

Answers

Sign In or Register to comment.