A
Alsok2
Hello. I need help with developing a formula for data extraction:
Spreadsheet #1 contains student data which my IT dept. imports into a student
intake database. Prior to import, however, I would like to extract test
score information from a second spreadsheet.
The common identifiers between the two spreadsheets are "Last Name" and
"First Name" to identify the students. The columns I want to extract and
place at the end of each student's data from sheet #2 to sheet #1 are
"Total", "Written" and "Reading". I know this can be done but I am unsure
because the record totals vary per sheet and I am just nervous because of the
sensitive nature of the material (test scores!)
Any help would be appreciated. Thank you.
Spreadsheet #1 contains student data which my IT dept. imports into a student
intake database. Prior to import, however, I would like to extract test
score information from a second spreadsheet.
The common identifiers between the two spreadsheets are "Last Name" and
"First Name" to identify the students. The columns I want to extract and
place at the end of each student's data from sheet #2 to sheet #1 are
"Total", "Written" and "Reading". I know this can be done but I am unsure
because the record totals vary per sheet and I am just nervous because of the
sensitive nature of the material (test scores!)
Any help would be appreciated. Thank you.