copy and paste if match and product

Please don't try to post an image. They're pretty much useless.
Will you please attach a sample Excel workbook? Please don't attach a picture of one.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Ok, thanks Glenn. So in the attached, you can see two sets of data. Master part numbers and their annual quantities, and the other set of data has a snapshot of orders, and it has the order number, part number and its quantity. What I need, as I highlighted with colors to make it easier, is to look up the part number (yellow) and find it's match in the master part number, then, compare its quantity to the master quantity (both blue) to see if it is 50% or more of the master quantity. If the part number from the order is greater than 50%, then copy and paste the order number (green), if it is false, then n/a. I was able to do it but it uses the number in the same row, which the part numbers in each column are not in order, so that's useless. I have been trying VLOOKUP and then an IF > statement, but I cannot seem to get it to spit out a correct response. Like my last problem, if I were to do this manually, it would take days, as there are over 4000 part numbers, so a formula that I can drag down or a combination of formulas that get me to the order number that has a quantity greater than 50%, would be great and save a ton of time. Thanks again for any help or direction.

Well I tried to attach the file, and it shows that my attachment is there in my preview, but it is not showing up when I post. I am not sure what I can do to attach this file now

Edit: I now see it has attached, so disregard this message.

Unfortunately your data are in a bit of a mess. In column B, 514181 is stored as a number. in column E, it is stored as text that looks like a number. the BEST solution would be to ensure that BOTH columns are TEXT (this will allow leading zeros, etc, to be kept). It would enable this formula (which currently employs a rather ugly workaround) to be simplified.

However, I'm not 100% certain that this is what you want (you did not show your expected results). Also, in one post you asked for the data to be copied if the ordered quantity was greater than stock, and in another post, you asked for the data to be copied if the ordered quantity was 50% or more than stock. Which is it to be? It's currently set at 50%...