Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Performing Fuzzy Lookups In Excel.mp4

K2 Enterprises
5.08K subscribers
<__slot-el>
<__slot-el>
58K views 12 years ago
Sometimes when using Excel's VLOOKUP and HLOOKUP functions, we don't get the results we are seeking, not because of anything we are doing wrong, but because the data we are trying to match together is not an exact match. For example, if you are trying to perform a VLOOKUP to find 123 Main Street, Excel will not match that to 123 Main St. Fortunately, for those who need to match inexact data, Microsoft offers the Fuzzy Lookup Add-in for Excel. In this tip, you will learn how to put this very powerful tool to work so that you can perform fuzzy lookups on your data. ...more
...more
Performing Fuzzy Lookups In Excel.mp4
84Likes
58,160Views
2012Jun 12
Sometimes when using Excel's VLOOKUP and HLOOKUP functions, we don't get the results we are seeking, not because of anything we are doing wrong, but because the data we are trying to match together is not an exact match. For example, if you are trying to perform a VLOOKUP to find 123 Main Street, Excel will not match that to 123 Main St. Fortunately, for those who need to match inexact data, Microsoft offers the Fuzzy Lookup Add-in for Excel. In this tip, you will learn how to put this very powerful tool to work so that you can perform fuzzy lookups on your data.

Follow along using the transcript.

K2 Enterprises

5.08K subscribers