Depends what you want. If you want to match identical data in the same row,
use EXACT as Skinman suggests. If you want to match data in different rows,
then it depends what you want in column C. Two suggestions:
1.
In C1 =IF(ISNA(MATCH(B1,$A$1:$A$10,0))=TRUE,"","Data matched")
This will enter "Data Matched in column C where the data in column B matches
a cell in column A.
2.
If you want to know where in column A the match is, then substitute "Data
matched" with MATCH(B1,$A$1:$A$10,0).
=IF(ISNA(MATCH(B1,$A$1:$A$10,0))=TRUE,"",MATCH(B1,$A$1:$A$10,0))
This will display the row WITHIN THE RANGE where the matched data lies. In
my example these will be the same, but if your range starts at A3, then the
match number will be 2 greater than the row number (eg a matched data in
sheet row 8 is row 6 in the specified range, so 6 will be displayed).
In each case, copy the formula down as far as you need.
