Hi guys, small query. Is there a way to return every occurence of a part
number from looking at one cell ... e.g. Cell C1 contains the one cell that I
want to use and cells D1:D4 contain the result I want to see, gained from the
data in A1:B6 .... so I want to be able to return the info from A1:B6 based
on C1 and input the data into cells D1:D4.

A B C D
1 Bob Car Bob Car
2 Bob Bus Bus
3 Bob Moped Moped
4 Mike Car Boat
5 Mike Bus
6 Bob Boat