Forum Discussion
vlookup - I think is what I need
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
figured it out...I just copy all my data making one long list, then I'm using the =if formula to see if all the data is the same, then mark it as duplicate - then I can sort everything based on that - and delete them.
Thank you for all who have looked at this and done some thinking about it.
