|Subject:||Vlookup only taking first line of data|
|Posted by:||Michael Dinning|
|Date:||Fri, 23 Jun 2006|
Hello all, this is my first time of using this - so, hopefully someone can
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
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.