Hi,

Can anyone assist with the following, please:

I need to separate information within columns so that I can return data belonging to an individual, for instance:

A B
Fred Oranges
Jim Apples
Alfred Bananas
Jim Cucumbers
Dave Carrots

I am using a Vlookup to return items, however I just need to return the results in this instance for Jim so that I can say Jim has Apples and Cucumbers. I know I can easily get a return from Vlookup for one item, which is where I'm currently at - it's just getting any remaining items for Jim that I'm having difficulty with.

Grateful for any thoughts.

Thanks,
Dan.