One simple play to take it out in adjacent cols ..

Assuming source data in cols A & B, data from row2 down
Assume the input for the desired product will be made in E1, eg: a

In D2: =IF(A2="","",IF(A2=E$1,ROW(),""))
Leave D2 blank

In E2: =IF(ROWS($1:1)COUNT(D:D),"",INDEX(B:B,SMALL(D:D,R OWS($1:1))))
Select D2:E2, copy down to cover the max expected extent of source data, say
down to E200? Minimize or hide away col D. Col E will return all the multiple
results sought for the product entered in E1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"confused" wrote:
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