From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Solve matching issues with matching phone numbers and SS numbers

Solve matching issues with matching phone numbers and SS numbers - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Solve matching issues with matching phone numbers and SS numbers

- [Instructor] If you work with data 2 that includes phone numbers or Social Security Numbers, 3 you will sometimes run into problems 4 when you're trying to match up data. 5 Now, you might be using the MATCH function 6 or a VLOOKUP function, 7 but when trying to reconcile data, 8 you might have some major problems. 9 In this worksheet, 10 we've got a list over in columns A, B, and C, 11 another list over in columns F through J, 12 that they both have phone numbers. 13 We want to match up the data. 14 Maybe the objective ultimately 15 is we want a new column D here 16 and we want the salary right here 17 based on the phone number. 18 And let's say we're assuming 19 that for every phone number here, 20 we can also find it over in column F. 21 Now, that might or might not be true, 22 but let's see what happens here 23 if we try and match up the data. 24 We should find some matches here, =match. 25 The match function…

Contents