exchange data between two files

[Guest]

Hi there;
first time here. I have two excel files: 1.xls and 2.xls
In 1.xls, there are 2 columns and 1000 rows. column A are English words,
column B are explaining about that words.

File 2.xls, have 2 columns, column A have same words as column A in 1.xls
file but not with same order, column B are blank yet.

Now question is how can I manage to do this: Click on (2.xls file, Col. B,
Row 30) then the explanation of the word appears there, in other words, the
equation or macro should find similar word in 2.xls col B, Row 30 in file
1.xls and then copy its explanation and paste it in 2.xls, Col B, Row 30.
Thanks for yoru help.
Best
Darius

 

[Vasant Nanavati]

In cell B30, enter:

=VLOOKUP(A30,[File1.xls]Sheet1!$A$1:$B$1000,2,FALSE)

or similar formula. Copy up/down to suit.