Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comparing Spreadsheets
Greetings friends. I hope you can help me out. Let me just say for the
record that I have no idea what a LOOKUP function does, so if it's as simple as that, I'm sorry to be a bother. I have two spreadsheets. One has a list of student IDs and student names. Another has a list of student IDs and test results. I want to compile the spreadsheets into one, using the student ID to match the two other pieces of data. The only thing I could think of was to sort the IDs numerically, which would work if both lists had the same exact students. But alas they don't. Many of the students didn't take the test and therefore don't have results, so it's not an easy sort/copy/paste function. Any ideas? Thanks much. Hank Harris Santa Monica-Malibu Schools |
#2
|
|||
|
|||
Hi
have a look at VLOOKUP. See: http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "HankHarris" schrieb im Newsbeitrag ... Greetings friends. I hope you can help me out. Let me just say for the record that I have no idea what a LOOKUP function does, so if it's as simple as that, I'm sorry to be a bother. I have two spreadsheets. One has a list of student IDs and student names. Another has a list of student IDs and test results. I want to compile the spreadsheets into one, using the student ID to match the two other pieces of data. The only thing I could think of was to sort the IDs numerically, which would work if both lists had the same exact students. But alas they don't. Many of the students didn't take the test and therefore don't have results, so it's not an easy sort/copy/paste function. Any ideas? Thanks much. Hank Harris Santa Monica-Malibu Schools |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
How do I get my actuarial spreadsheets to comply with SOx? | Excel Discussion (Misc queries) | |||
Please Help (Comparing Spreadsheets) | Excel Worksheet Functions | |||
How can I get a total across multiple spreadsheets? | Excel Worksheet Functions | |||
Comparing Data in two columns | Excel Worksheet Functions |