merge data from 2 Excel files

[Maileen]

Hi,

I have 2 excel files (A.xls and B.xls) with some data.
In one of them, i want to do the following task :

- from file A.xls, look for value of column A, and check if exists in file
B.xls
- if yes, take value of column C from file B.xls, and write it in file A.xls
(Column G)

and this for all data of my column A from file A.xls.

is it posible to use worksheet function for that ?

thx,
Maileen