database - Matching unequal columns in excel -

database - Matching unequal columns in excel -

i have list of people have completed intelligence test (names stored in column d) , alphabetical list of people have completed sec intelligence test (and scores) in columns , b respectively.

the list of people stored in column much bigger (n = 3000) list in column d (n = 800). need match column (and scores) column d, whilst keeping column d in order in.

i have tried various match , vlookup functions not accomplish like. can point me in right direction please?

did seek straight foward vlookup?

=vlookup(d2, a:b, 2, 0)

and drag down

database excel sorting