These two data sets can be matched using the fuzzy matching option.Ĭolumns G and H show a translation table that will be used by the fuzzy match to help match full first names with their nicknames. Unfortunately, a VLOOKUP or XLOOKUP won’t work since column A uses a “last name, first name” format while column D contains a nickname and last name. You need to identify the people who haven’t yet returned the form. Columns D and E contain the names of the employees who filled out a required form. Columns A and B contain the list of employees. Figure 1 shows two data sets that need to be matched.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |