Excel how to find values in 1 column exist in the range of values in another -

i have 2 columns- column extends upto 11027(values) , column extends 42000(values).both columns contains code details.

something this

a               b q123           as124 as124          gh456 ff45           q123 dd1             dd2 xx2 xx3 xx4

and on...

i want find if names in column exists in column b or not.using excel

this need:

 =not(iserror(match(<cell in col a>,<column b>, 0)))  ## pseudo code

for first cell of a, be:

 =not(iserror(match(a2,$b$2:$b$5, 0)))

enter formula (and drag down) follows:

enter image description here

you get:

enter image description here

Code wiki