E
ExcelInExcel
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?
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?