Beginner trying to compare cells in two columns and copy a third column if it is a match

Hello, I am a beginner at this so please excuse me if I don't make myself entirely clear but Ill try!

I want to compare two columns of cell values and when there's a match, a value from a third cell in a third column needs to be copied to a fourth column, right next to the first two columns.
I am ordering items from a company and I want to match their product number to the amount we want to order. Our ordering systems puts out an excel sheet with prod number in one column and amount we want to order in the column next to it., I want to match two columns containing order number (our systems and the official order form, they use the same formula) and then add our column of "amount ordered" should be added to its respective item row.

I suspect using MATCH or INDEX is a start but I haven't been able to get it to work.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

Still don't understand. There are no matching entries.

Oops, you're right, I shortened the list and didn't check whether anything actually matched (in the full file there is roughly a thousand product codes in column C, and we're buying maybe 150 of those in varying amounts (listed in Y)
I have update the file with a better selection of data.

Hi,

In C3 enter
=IFERROR(INDEX($Y$3:$Y$12,MATCH(D3,$X$3:$X$12,0)), "not found")

and drag down

It works in your sample sheet:

AliGW on MS365 Insider (Windows) 64 bit

	C	D
2	Order	Product Code
3	not found	01-05
4	not found	01-07
5	not found	01-08
6	not found	01-10
7	3	66-27
8	2	64-60
9	not found	01-12
10	1	29-37
11	not found	01-14

Sheet: NE Trade

You're welcome. Thanks for the rep.

I feel the other guys did the heavy lifting, but thanks anyway.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.