I have two spreadsheets of school names. One spreadsheet contains 11 columns without headers. Column K contains data that needs to be copied to the other spreadsheet.
The destination spreadsheet also has 11 columns, but with headers. The information from Column K of spreadsheet #1 (High-Schools-2014-with-PA
AK) needs to be copied to spreadsheet #2 (high-schools-Destination-
File). However, the information in each cell in column K must match with the correct school name.
Not every school in the destination file appears in the first file, therefore would not have data copied over to column K. There may be schools in spreadsheet #1 that do not appear in the destination file.
I need some type of formula that will look at the school name in Column A, copy the data in Column K, and paste into the proper cell in the destination spreadsheet corresponding to the same school name.
Is this possible?