Two columns

B

BPR

I have two colums: A and B, both containing text. In A I have 15000 rows, in
B I have 1000 rows. I need to identify the rows where values in A also are in
B. How can I do this?
 
H

Harald Staff

One way, in D1:
=NOT(ISERROR(VLOOKUP(A1,$B$1:$B$1000,1,FALSE)))
Fill down to D15000

HTH. Best wishes Harald
 
Top