How to Lookup Names with Spelling Errors (All types of Spelling mistakes), Excel Vlookup and Xlookup
Вставка
- Опубліковано 28 сер 2024
- Course Alert:
If you would like to learn in detail, how to calculate income statement variances and the impact they have on sales $, profit $ and profit margin % and ebitda %, and how to explain performance vs budget and prior periods, click on the link for a detailed video course (at a special price). You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates. ebitda.thinkif...
Looking for more personalized help?
Get in touch with me on one of these platforms:
Instagram: / learnaccountingfinance
Facebook: www.facebook.c...
Tiktok: / learnaccountingfinance
Website: www.learnaccou...
Subscribe: www.youtube.com...
How to lookup and have an exact match between two columns where the spellings are different with all kinds of spelling mistakes, spaces and characters? In this video, I will show how you can use Excel fuzzy lookup tool to solve this time consuming problem.
Download Excel file to practice along with me: bit.ly/36TX8OB
Learn what financial numbers really mean here: amzn.to/2HPYDUI
Are you a First Time or New Manager? Check this out: amzn.to/35qWzLc
Learn all about Excel in one place: amzn.to/3laCXQx
Here is the Link to download the Excel Add-in called Fuzzy Lookup: www.microsoft....
Often you find yourself comparing two reports or data sets where the names or text strings are similar but do not match exactly. As a human, you can tell that they are the same, but you cannot look up data using the exact match features of Vlookup or Xlookup. In this case, the Fuzzy lookup tool comes in handy. In this video, I show you how to install and use the Add-in to lookup Company names, or Customer Names from two separate data sources, so that you dont have to spend time manually finding the names and then copying and pasting the values from one table to the other.
I have used this method when trying to compare sales reports from two different sources which have the customer names, one report has the freight costs by customer and the other report has the sales by customer. When I try to bring the two together by using a vlookup or an Xlookup, I am unable to do that because the names do not exactly match. In addition, the differences in spelling do not follow a set pattern, so I cannot even use wildcard matches or be creative about using additional Excel formulae to help with the lookup. In this case technology becomes really useful. My recommendation is to use the Fuzzy lookup tool or add-in which can be downloaded from the Microsoft website and installed in Excel. This is such a time saver.
I will show in the video the setup of the tables to use the fuzzy logic add-in as well as the use of the "Similarity threshold" to help lookup majority of the company names in the example. By the way, the sample data includes Revenues and Net Profits for 25 of US top Fortune 500 companies by revenue. You can also download the sample Excel from the link provided.
Hope this video helps!
Connect:
/ learnaccountingfinance
www.learnaccou...
Subscribe:
www.youtube.com...
Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance #lookupnames #spellingdifference
Excellent! I found what I was looking for and it simply and perfectly explained!! Congrats. Thank you.
So useful, i got what I'm looking for
Glad it helped.
Wish I would have found this last week! Awesome tips
Glad it was helpful!
Thank you very much. Nicely expained.
Thanks Neil.
excellent add-in. Thank u.
hi can i know if not the spelling mistakes or partial match. how about different sentences or name sequences? example, I want to look for the status payment for this company and in my file there is PT. Mulia Intan Jaya, and other file that have status, the name is like Mulia Intan Jaya, PT. can i know what exact formula for kind this situation? thank you..
thanks boss, this has helped me a lot
glad it helped!
Great video with Great Quality
Thank you Avinash
Thank you sir, most helpful video
Thank you Yazied.
Exactly what I was looking for thank you !
Thank you Jose. You are welcome 😊
Fuzzy not working. Pop up window showing 'must define at least one fuzzy join'
Thanks alot
You are welcome!
is it safe to download fuzzy lookup in office laptop? need to get approval though. I desparately need this
Should be ok but check with your IT / policies to avoid trouble.
Does not work for mac