I need to lookup and insert values from sheet 1 into sheet 2. names are not
always alphabetical and can change order.
a b
1 name type
2 fred A/L
3 fred PDO
4 fred S/L
5 bob A/L
6 bob PDO
7 bob S/L

there is always 3 results for each name to be copied from previous sheet.
can only get first type returning in place of the others for each name.

Can anyone suggest something.
thanks