Hi all

I have a large pivot table and filter on a name field, doing this returns back a mass of data for a certain user which I need to be able to extract via looks ups.

I have used a VLOOKUP but the issue is this only returns a single peice of data, in my pivot there are instances where multiple values exist for that user...

e.g. (the items in italics are the headings and the rest is data)

Name
John Smith > Colour
Red
Blue

In this example the pivot is filtered on the user John Smith and this returns Red and Blue. Using a VLOOKUP I would only get the Red returned but would need the values Red and Blue returned, what is the best way of doing this?

Thanks for any suggestions.