Easiest way to compare 2 columns of text?

[Morba]

Any help would be appreciated.

Have 2 lists of numbers (1 list 250 or so, other list is over 10k), im looking to compare the 2 lists and create a 3rd list of all numbers that appear in both lists.

can be done in excel or access, whats easiest?
i really dont want to sit here manually doing it

ive been told to use vlookup in excel, but the help file doesnt seem to be helping me :/

Thanks

 

[Morba]

funny you should say that, its what i ended up doing.
83 records came back as in both

thanks :]