Vlookup only taking first line of data

M

mickyd67

Hello all, this is my first time of using this - so, hopefully someone
can
help.

I am looking to do the following:

I have a part number - for instance 12345

I have a number of open purchase orders for that part - which are all
listed
on a rather large file with a number of other open purchase orders.

What I want to do is take all the open purchase orders for that
particular
part and 'pull' them into another file. I would do this by looking up
the
part number and pulling each induvidual line item of information into
another
worksheet.

Vlookup only takes the first value it gets to - how can I make it take
the
1st, 2nd, 3rd lines of information?

Thanks for your help.
 
Top