Vlookup only taking first line of data
 

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.


--
mickyd67
------------------------------------------------------------------------
mickyd67's Profile: http://www.excelforum.com/member.php...o&userid=35704
View this thread: http://www.excelforum.com/showthread...hreadid=554891