In , Jasdf spake
thusly:

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.

Are we to presume the files are both open? I hope so. Natively,
Excel would want them to be. There are add-in functions that can
get around that, though. The next question is, are you really only
looking for "b" in Column C? Or is that just an example of something
more complex?

Anyway, what you've said so far doesn't seem all that "complicated"
to me, provided both workbooks are open and you really only want Column
C to display any "b" values it finds from that columnn in the other book.

As one way, in C1, and drag down as needed in Column C:

=IF([Book1]Sheet1!$C1="b",[Book1]Sheet1!$C1,"")

Substitute the real book name for "Book1"; substitute the
real sheet name for "Sheet1".

-dman-