How to Use Microsoft Excel Fuzzy Lookup

[@realmehranvahedi]

Dear awesome viewers! Thank you for your amazing engagement! Remember, the most liked comment gets pinned - so start liking your favorites now! I love your questions and will try to respond to as many as I can. For quick generic queries, the comment section is perfect. But need more in-depth, personalized advice? Book a personalized consultations with me via topmate.io/mehran_vahedi. They're ideal for detailed, specific questions. Your support means the world to me. Let's keep the conversation going! Thank You!

[@abhiadfree6331]

Great video..what if there are 100 lines in List 2 and only 20 in List 1 to match? Will list 1 entries run through all the 100 lines of List 2 in fuzzy lookup?

[@joaquinposadas5561]

This helps a great lot. Thank you kindly!

[@realmehranvahedi]

You're very welcome! I'm glad it helped.

[@wla3438]

Thnk you for info

[@realmehranvahedi]

Thank you very much for leaving a comment. I am glad you found the video useful. If you haven't already, make sure you subscribe and turn on notifications. I will be publishing MANY more cool tutorials in the upcoming weeks!

[@meredithhurston]

Thank you! Just what I needed.

[@realmehranvahedi]

You're very welcome! I'm glad the video helped. Stay tuned for even more cool Excel tips and tricks!

[@abcd1236214]

great content

[@realmehranvahedi]

Thank you very much for leaving a comment. I am glad you found the video useful. If you haven't already, make sure you subscribe and turn on notifications. I will be publishing MANY more cool tutorials in the upcoming weeks!

[@NismiNavoda]

Thank you! This is really helpful

[@realmehranvahedi]

You're very welcome @NismiNavoda. I'm glad you found it useful. Stay tuned for even more near Excel tips and tricks.

[@chloec919]

thanks ! it's really helpful !

[@realmehranvahedi]

You're very welcome! I'm so glad to hear you found the video helpful. Your support means a lot and helps us keep creating content that makes a difference. Thanks for watching, and I hope to see you in future videos!

[@90plus44]

so easy to understand😍

[@realmehranvahedi]

Thank you so much, @90plus44! I'm thrilled to hear you found the video on Microsoft Excel Fuzzy Lookup easy to understand 😊. Stay tuned for more tips and tricks, and feel free to suggest any Excel features you'd like to see explained in future videos!

[@munirzaki7027]

Thank you so much!

[@realmehranvahedi]

You're very welcome. I'm glad you found it useful!

[@anamariarodriguezcortes8737]

Great Video! Thanks!!!

[@realmehranvahedi]

Hi Ana Maria, thank you so much for the comment. I am glad you found the video useful. If you haven't already, make sure to turn on notifications so you won't miss out on my future videos. Thanks again and take care!

[@GODVAN1]

Can vba run it in same setting each time?

[@realmehranvahedi]

Hello @GODVAN1, Yes, you can use VBA to automate the Fuzzy Lookup process in Excel. By creating a macro, you can configure a VBA script to run the Fuzzy Lookup with the same settings each time. Here’s how you might set it up: Step 1: Record a Macro - Begin by recording a macro while performing a Fuzzy Lookup to capture the necessary steps. Step 2: Edit the Macro - Once recorded, you can edit the macro to fine-tune the settings or parameters according to your needs. Step 3: Assign to a Button - Lastly, you can assign this macro to a button on your Excel sheet, allowing you to run the Fuzzy Lookup with a single click using the same settings every time. This method ensures that the Fuzzy Lookup is performed consistently, making your data analysis process more streamlined and efficient. Let me know if you need a more detailed walkthrough or any specific code examples! Best regards, Mehran

[@GODVAN1]

@@realmehranvahedi thank for your reply, but macro record function not applicable for the fuzzy lookup.

[@inannibras391]

Thanks but here is my problem. My Table 1 has less companies than Table 2. I want to match company names of Table 1 to Table 2 and extract opening balance from companies in Table 1 to same companies Table 2. So companies that aren't in Table 1 will have no data in Opeaning Bal colmn in Table 2

[@realmehranvahedi]

Hi @inannibras391, thanks for your question! It sounds like you're looking to perform a left join using Fuzzy Lookup, where Table 1 with fewer companies is your left table and Table 2 is your right table. To do this, set up your Fuzzy Lookup to match the company names from both tables. Make sure to include the 'Opening Balance' column from Table 1 in the output columns, so it transfers to Table 2. For companies in Table 2 that don’t find a match in Table 1, the 'Opening Balance' column will remain blank, or you can set it to a default value like $0 or 'Not Available'. If you need more detailed steps or a tutorial on setting up the Fuzzy Lookup tool, let me know! Also, for detailed guidance on specific cases, consider booking a personalized session with me at topmate.io/mehran_vahedi. Looking forward to helping you further!" This version offers comprehensive help and directs the viewer to your booking page for further assistance.

[@nipu9970]

Thank u so much...its really helpfull

[@realmehranvahedi]

Hello, thank you very much for leaving a comment. I am glad you found the video useful. Make sure you have your notifications turned on so you will get notified everytime I post a new video. Thanks again for the comment and take care.

[@waimingkwok-x1h]

Can it launch with the VBA code?

[@realmehranvahedi]

Great question! Yes, you can use VBA to automate fuzzy lookup operations in Excel. This would involve writing a macro that sets up the fuzzy lookup parameters tailored to your data needs. I’ve noted your interest and might consider creating a tutorial on this topic in the future as part of my planned content. Stay tuned, and thanks for the suggestion!

[@wilmarkjohnatty4924]

The problem im getting is that everytime i run fuzzy lookup and i want to go back and redo the lookup, its corrupted and will run incorrectly leaving out columns, not identifying the tables etc. I have to copy the fresh data into a new sheet and start over.

[@realmehranvahedi]

Hello and thank you for leaving a comment and sharing your experience with Fuzzy Lookup. I have not experienced that issue myself but I'm sure there should be a way around it.

[@zukiswanodipho7435]

how do fuzzy lookup using 3 tables

[@realmehranvahedi]

Great question! Fuzzy lookup in Excel is typically designed to work between two tables by comparing one column in each. To work with three tables, you would first perform a fuzzy lookup between two of the tables and create an intermediary result. Then, you'd use this result to perform another fuzzy lookup with the third table. This process involves multiple steps and careful setup to ensure the data aligns correctly across all tables. I'll consider covering this in more detail in a future video if there's more interest. Thanks for your question!