Multiple Lookups To Create Form

[DavidOB]

Hi everyone,

I have been trying to get my brain round this Excel issue I have. In a nut shell, I have 3 sheets; Sheet 1.1 shows customer order numbers and adresses, which we need to ship stock to; sheet 1.2 are the stock items/codes we need to ship to the customer (the order number is the common number between the two sheets); sheet 3 (Despatch Doc) is where i need to return the data.

So, on sheet 3 i want to use a drop down to select the customer order number, this will then populate the ship to addresses and any other customer information. This is created already. However, in the main body of the sheet is where i want to populate the part numbers ordered/despatched. As the the customer order number is repeated in sheet two I'm finding it difficult bringing in the stock codes for the customer order.

I have attempted to use MATCH and IF but didnt work.
The data in sheets one and two (where the header is black) will be pasted from a csv file received from another feed.

Any chance you could help with this?
Sheet 3 will be used to print customers orders for despatch purposes.