The simplest solution is to use AutoFilter. You can then display only rows
that have an "a" in column A and copy the data elsewhere.
--
Gary''s Student - gsnu200790


"confused" wrote:

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