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!
Bookmarks