Populate my Purchase order from a list of Purchase Order numbers and their details

Hi
I am new to this site and would be grateful if anyone can help with my problem :o).
I have created a blank Purchase order on a work sheet, and I have a Purchase order list in another worksheet, that 4 people populate with the relevant details, e.g. supplier, quantity, PO number, description of goods etc.

I want to be able to pull all these details into the Purchase Order. I was ok with vlookup using the PO number as the driving force, but it will only enter the first row of details that are relevant, but the PO number in the list has multiple lines if items. This is where I am stuck.
Thank you in advance.

Hi,

See the file attached.

I had to remove 1 merged cell to make use of the array formula-

Please Login or Register  to view this content.

Glad to have helped..

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.