CatsIgnoreMe
New Member
- Joined
- Feb 8, 2016
- Messages
- 15
Forgive me for a basic question, but I'm having trouble wrapping my mind around the best way to this. I have 5 columns of data from our existing records: School | Position | Name | Email | Phone and the same 5 columns of data from an updated source. I want Excel to compare to two sets of data. If there is a match, then a value of "Keep" (or any other value to represent "Keep"). If no match is found, the formula would return "New". Thank you for your help!