I have an Excel file that contains two different columns having Customer Numbers (let's say CustomerA and CustomerB columns). What I would like to do to check which of the CustomerA values match the CustomerB values. Is it possible?
Update
@sancho.s: Here is the excel file and values I used.There is no error and no value as you mentioned on your answer. But after changing some values in the formula I get error "There is an error in teh formula...". Thanks for your kind help.
A B C D
1 CustA InB
2 6077890 =MATCH(A2,$D$2:$D$5,0) 6077890
3 48414792 5861291
4 50267662 3082960
5 51242034
6 6079377
7 6077580