Hi,

Base on yor posted data this works. Out it in D1 and drag down to d4.

=VLOOKUP($C$1,$A1:$B$6,2,FALSE)

Mike

"John Moore" wrote:

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