i have a master list having about 400 families and their member numbers
as follows

10/00 james
10/01 john
10/02 andrew
10/03 peter
10/04 mike

21/00 jane
21/01 moses
21/02 lucy

where */00 is the main member
i have another 2nd list having a version of the list as follows

10/00 james
10/00 john
10/00 andrew
10/00 peter
10/00 mike

21/00 jane
21/00 moses
21/00 lucy
21/00 (someone who shouldnt be here)

however some families in the second list have more members than in the
master list whereas others have less members

ive been using vlookup in a helper column in the 2nd list only but it
isnt very helpfull here since it lists for me only the main members as
seen in the masterlist ( but has been helpfull in seeing the missing
families)

is there a simple way perhaps using both vlookup & hlookup or any other
functions (without using macros if possible) to help me easily see the
problem families and the problem members.



thanks