Why don't you Autofilter column A for product a? Doing this you'll see on
ypou screen merely
Product Component
a xx
a xw
a ww

A more complicated question if you want to see in the same run components of
product xx as well!

Regards,
Stefi


€žconfused€� ezt Ã*rta:

Hello,

Is there any was to use vlookup to retrieve more than the first entry. My
spreadsheet is as follows...

Product Component
a xx
a xw
a ww
xx 11
xx 12
12 abc
12 def

So each product is made up of numerous components, and these components
themselves are made up of sub components.
If I vlookup product A I can retireve component xx, but not xw or ww . Is
there any way of doing this??

Many thanks,

Willie