Merging two files and delete the non equal lines

I have two Excel files:

Both files containg two columns:
File 1: Article Code, Article Name (1800 lines)
File 2: Article Code, Price (2000 lines)

The best would be if I can get the prices from File 2 in a third column after article name in File 1 and then all those lines that are not in File 1 compared to File 2, will be left out of File 1.
The second best is just to get the prices from File 2 in a third column after article name in File 1.

Is this possible?

I believe the VLOOKUP function will do exactly what you want.
Can't give you a formula without a sample sheet to work from, but should be something like:

For Cell C1 (of File 1) =VLOOKUP(A1,'[File2.xlsx]Sheet1'!$B$1:$C$2000,2,FALSE)

That assumes that cell A1 (in file 1) contains the Article Code, and that the Article Codes and Prices are in the range B1:C2000 (in file 2).

I get the information pop up (Functionagrument)

I tried the solution from Ankur and it worked successfully with your posted test files.

Did you change "," to ";" in the formula (as I think this is the general European convention) ?

Yes, but still the same pop up. Do I have to have both the files open?

Hmmm, now I get #NAME? in the cell

Got it! Translation into Swedish:

=OMFEL(LETARAD(A1;'[Example File 2 .xlsx]Blad1'!A$1:B$19;2;0);"")

Thanx a million!