I am trying to match phone logs against data that a user says they have called. One sheet contains the phone logs, the other sheets contains the user info that has when they said they called and what number they called. I need to return in the 3 columns in the sheet if it finds the phone number against the call log, how long the call lasted, what # was called, and what date it was called on. Another issue is the phone number can be altered on the call log, so one would have "555-555-5555" but the call log could have it as +1 (555-555-5555). Any ideas?
Sheet posted is basically what i want to happen, thanks as always everyone!
Bookmarks