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

 

[ByteJuggler]

I'd probably be tempted to shove both lists into tables in Access or some other database, and then do a simple sql query to find the ones that appear in both, something like: select * from list1 inner join list2 on list1.key = list2.key. Getting the lists into Access can likewise be done possibly via a text import or by generating insert into statments for each line of text, using a suitably powerful text editor. Should take all of 5 mins, if that.

 

[Morba]

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

thanks :]

 

[Seft]

Try KDiff3