Or can use pivot table.This will even show the cells in Col B whose
contents match those in Col A
the cells
in Col A whose contents match those in Col B

Pls mail me the file if you feel.