Compare two sheets, copy from one if values match

[teaker]

Gooood Morning Everyone!

I have two excel sheets: 1 (Chapters.xml) with a list of an organization's chapters (about 250) and another with the president of each chapter (presidents.xml). Is there a way that I could compare a list in "presidents" to each value in "chapters", and if the value matches copy the respective value from presidents to chapters?

For example:
Chapters: A1= Alabama Mu
Presidents: A8=Alabama Mu B8="John"

I would like to compare each value in Presidents column A to Chapters column A. In the above case, "John" would then be copied to Chapters A2.

Thanks in advance!

[ravishankar]

Hi
try in chapters file
B2=Vlookup(A2,[presidents.xml]Sheet1!A1:B100,2,false). pull down the formula till the end of data
Ravi