Match cell in two files and copy cell to another file

[airflame]

I have two files

1. File with 2x columns (A) SKU CODE, (B) LinkS to IMAGES in one line
2. File with A,B,C,D,E columns (A) SKU CODE

Is there a way to check file 1. each of (A) column if exist in file 2 in (A) Column. If there is a match it will copy file (1) column (B) cell to file 2 to column F cell

File one example:
5904509002032; https://site1.com/img/img1.jpg, https://site1.com/img/img2.jpg

File two example:
5904509002032; 0954-3269816-000; 0954-3269816-000-S; Abella

Those two files have allot of other cells between and cant be sorted A-Z or Z-A i need solution i posted above.

I can copy (file 1) to (file 2) to I,J,K,L,M,N etc if this help.

Editt:

Cell where i want to paste copy the links if match is 0

=IF($M1:$M2114=$B21;$N1:$N2114;)

[BigRAl]

@airflame,
Should this post be re-tagged calc(accurate tagging helps others looking for solutions)?

[airflame]

Changed to calc