Using old and new stock lists, determine stock used

Hi all new to excel sorry for the newbie questions any help appreciated

ok I have two excel worksheets 1st old stock list 2017 and 2nd new stock list 2019 in the list i have approximately 500 records

old 2017 NEW 2019 Result Sheet

1 Part Number | Actual Stock Number | Bin Part Number | Actual Stock Number | Bin Part Number | Actual Stock Number | Bin
2 PT08715529 155 a00-00 PT08715529 78 a00-00 PT08715529 77 a00-00
3
4
-
-
500 PT376433536 ......etc

I would like to query old against the new and have a result or showing me number used, i think its done via vlookup but not really sure where to start, also is there a wizard i could use to do these if yes what the best tool to do it many thanks

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Newbie to excel" is not a good title. I have updated it for you this time because you are a new member. --6StringJazzer

Welcome to the Forum raytexcel!

Do you just want a single number as your result?

Can you explain how your data is set up--do you have multiple parts on the same row?

Where do you record quantities?

Please attach a file(s) with your sample data. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Selecting the attachment results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator"
Please follow 6StringJazzer's directions to upload a workbook.
Let us know if you have any questions.

Although I am not a moderator I feel safe in saying that is a screen shot, a "file" would be the .xlsx from which the screen shot was taken.
Let us know if you have any questions.

I am guessing that the part numbers come from column G, the date of correction (if there is a difference in number between columns C and I) is 7.7.19, "Add" means there are more parts in 2019 than there were in 2017 and "Remove" means that there are fewer parts in 2019 than in 2017.
If so:
1. Populate column L using: =IF(G4<>"",G4,"")
2. Populate column M using: =IF(OR(N4<>"",O4<>""),DATE(2019,7,7),"")
3. Populate column N using: =IF(L4="","",IF(C4<I4,I4-C4,""))
4. Populate column O using: IF(L4="","",IF(I4<C4,C4-I4,""))
If this isn't what you want please give examples of what you want along with explanations of the reasoning that goes along with the examples.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.