Forum Discussion
vlookup - I think is what I need
I'm a school testing coordinator. I have an initial list of students with several descriptors.
What I want to do, is keep the above list as my original - then every so often, maybe monthly, I will take my current enrollment (with all their descriptors) and compare that new list with my original list.
When I make that comparison - I want to take all the new students (and their descriptors) and move them to my original list - without erasing any of my original students - I'm sure there is a function for that, I believe vlookup is that function - but so far, I haven't had any luck in getting it to work.
and Yes, one column is a unique student ID that can assist with all this.
Thank you for any help,
Wes
Wes-
Vlookup is indeed what you need. Based on the description of your scenario I think the below example will help you accomplish your task. I'm attaching an example .xlsx file for reference as well.
Thank you for your help!
okay, I see what this did, pretty cool.
Let's say that the second list was comprised of all the first list, but added about three more students and addresses, etc.
Can I compare the two lists and have it automatically add those three new rows of data - without replacing the original students?
Or, say I have 10 students originally...I want to keep all this data.
the next month, I get three new students, but 4 of my original withdraw. I don't want to lose those 4 pieces of data, but I want to add the three new ones...will this work for me? so that even though I have 9 students currently enrolled, I still want to keep track of all 13 student's info.
Somebody just gave me a good idea - but I don't even know what the formula might be...
They suggested that I take the new student list, and add it to my first list - now instead of having a list of 800 students it might be 1600 - then I search for duplicates and delete them. Is there a formula or function that would delete duplicate rows?
That might be easier than creating a vlookup
