Adjust this Excel Spreadsheet

I WILL SEND ON THE FILES AFTER THIS IS TO GIVE AN IDEA Step 1: Search all the product IDs from the priceList [login to view URL] file in the [login to view URL] file column A (split the "Order ID -" part from the cell if that helps you search...). Step 2a: (If there are no corresponding matches) Find *any* variation of the product in there - as found by looking the products above/below it in priceList [login to view URL] (e.g. - CS-PAV-V134A and CS-PAV-V134A) and create a NEW ROW under it and post the order ID in column A of [login to view URL] (but give it the same product ID (column D in [login to view URL]). CREATING A NEW ROW: You create new entries for columns A, B, C, F, R in [login to view URL] based on whats in the priceList [login to view URL] and you can use the same entry for ALL OTHER COLUMNS as the variant(s)* that you found. *A variant is the same product in a different row with a different column A, B, C, F, R (sometimes R - price - is the same and sometimes its different. Check in the priceList) in [login to view URL] - in reality this is usually because its the same product in a different colour/size etc sometimes with a different price - check the priceList for that. Be sure to differentiate variants by what you write in column C. Step 2b: (if it is there): Do nothing! I estimate 30-40% will be there, and the other variations will have to be inputted as new rows. Repeat until you've went through the whole of priceList [login to view URL]!