vlookup multiple returns excel -

i working data set of students information @ local university.

i used vlookup, using ids of students unique identifier. problem vlookup requires 1 row of information , half of students in study have more 5 lines each. how can make excel return multiple lines?

vlookup return first row matching or closely matching condition depending on last boolean function parameter. assumed id unique , not repeated several times in table searching in.

as far understand issue, either find way make unique key lookup table key loking 'id + column' formatted in unique way such 'id - other id' or have use vba retrieve rows matching non unique condition.

if job @ hand small, or vba cannot considered, , acceptable work out manually using auto filters matching/retrieving help.