At the top you can identify the tables you want to use. A pop-up dialog box will appear allowing you to identify several aspects of the process. Once done, click on the Fuzzy Lookup icon on the Fuzzy Lookup tab in the ribbon. Once done you may have to shut down and restart Excel you should see an additional tab on your ribbon.Īlso, you can only do this with two tables, no more. You can download that add-in from Microsoft at the following link. However, the problem here is that the information I would use for a match, first or last names, do have some discrepancies. Here are two lists I have where I want to extract the ID from the first list and attach it to the second. If you see a preview, look for the download arrow in the upper right hand corner. What do you do when you need to perform lookups in Excel and the data only sort-of matches? Use Fuzzy Lookup, of course! You can download the file here to follow along.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |