I am having two exel files. I need a macro that looks at the number in file1
cell B2, searches that number in file2 column B and copies a number in that
row (Mx) to cell C2 in file1. It has to do that for the whole column B in
file1.

I found some simmilar tutorials, like this one:
http://cpearson.com/excel/duplicat.htm

but I can't figure out how to do exactlly what I need.

Any help would be great!