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!
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?
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!
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!
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!
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!
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.
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!
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.
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.
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!
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!
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
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!
Thank you! This is really helpful
You're very welcome @NismiNavoda. I'm glad you found it useful. Stay tuned for even more near Excel tips and tricks.
Thank you! Just what I needed.
You're very welcome! I'm glad the video helped. Stay tuned for even more cool Excel tips and tricks!
This helps a great lot. Thank you kindly!
You're very welcome! I'm glad it helped.
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?
Great Video! Thanks!!!
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!
so easy to understand😍
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!
great content
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!
thanks ! it's really helpful !
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!
Thank you so much!
You're very welcome. I'm glad you found it useful!
Thank u so much...its really helpfull
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.
Thnk you for info
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!
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.
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.
Can it launch with the VBA code?
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!
how do fuzzy lookup using 3 tables
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!
Can vba run it in same setting each time?
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
@@realmehranvahedi thank for your reply, but macro record function not applicable for the fuzzy lookup.