Join Dennis Taylor for an in-depth discussion in this video Solve matching issues with matching phone numbers and SS numbers, part of Excel Tips Weekly.
- [Instructor] If you work with data that includes…phone numbers or Social Security numbers,…you will sometimes run into problems…when you're trying to match up data.…Now, you might be using the match function…or a Vlookup function, but when trying to reconcile data…you might have some major problems.…In this worksheet, we've got a list over in columns…A, B, and C, another list over in columns F through J.…Note that they both have phone numbers.…We want to match up the data.…Maybe the objective ultimately is…we want a new column D here…and we want the salary right here based on the phone number…and let's say we're assuming…that for every phone number here…we can also find it over in column F.…
Now, that might or might not be true.…But let's see what happens here…if we try and match up the data.…We should find some matches here, =match.…The match function allows us to say…we've got a value somewhere.…It's in cell A2 in the example here, comma.…We want to find this in column F.…Now for the moment,…we're not trying to pull in any other data.…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.