View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ExcelInExcel ExcelInExcel is offline
external usenet poster
 
Posts: 1
Default Compare two lists

I have two lists list1 and list2

List 1 List 2
a b
b d
c e
d
e

Is there a way I can get the items in List2 that already exist in List 1
(b,d,e). It looks simple for the lists above but when I have lists with 100
or so items, it is not so easy.

thinking about it, will a vlookup do the job?