Forum Discussion
Compare and Validate Data between 2 Files
HI All, I'm looking for some help with one of the projects monthly excel tasks. So We have a People Roster and this people roster contains names of all the people who have worked and still ...
Kris -- In the attached spreadsheets I've given you a quick and dirty solution, using VLOOKUP to see if there's a match in the other roster, and Conditional Formatting to highlight when there's no match found.
It's quick and dirty totally. Depending on the size of the issue, it would work. As I indicated in my earlier posting, though, I'd strongly recommend trying to get at the deeper issue that causes there to be these discrepancies in the first place.