This is my problem:

First file

A B C
1 x a
2 y b
3 z c
4 q d
5 w 3

Second file:
A B C
1
2
3
4
5

Now i need to create something to search first file and when it finds that
in row 2 value in column C is b, it needs to copy value b and paste it in
second file in row 2 under column C.
I would be grateful for any help.
Thank you.