Log In
Register
Home
March 10, 2016
Offline
בקובץ המצורף יש לי 3 דוגמאות של בעיות שאני נתקל -
פונקציית Vlookup לא יכול לייצר את התוצאה כי אין דיוק בשמות
איך אתה מגדיר פונקציה שתכין את התוצאה גם אם אין דיוק בשמות -
מפרט את השאלות בקובץ
תודה על התגובה!
See Answer
VIP
April 21, 2015
Offline
Hi Lea,
It's written in something else than English? Can't read it, can't help you.
Sorry!
VIP
Trusted Members
June 25, 2016
Offline
Hi Lea
Thanks to Google Translate I am able to read what you have written 
What you need is a type of Fuzzy lookup. There is a free add-in available that you can download from the internet.
Attached is a custom function than I found. You can get more details from here :
https://www.mrexcel.com/forum/.....ation.html
It is very good and should do what you are asking for.
Hope this helps.
Sunny
Answers Post
March 10, 2016
Offline
Thank you for your answer and patience even when I write in Hebrew and translate ...
I do not know VBA - how do I run the code in a new file?
Thank you!!
VIP
Trusted Members
June 25, 2016
Offline
Hi Lea
1) Open my earlier attachment (Lea-Cohen-Fuzzy-Lookup.xlsm) together with your new file.
2) Press ALT-F11 to open the VBA window (refer diagram attached).
3) On the left you should see the names of both the open files. You should see a Module 1 in Lea-Cohen-Fuzzy-Lookup.xlsm
4) Drag and drop Module 1 to your new file.
5) Press ALT-F11 to close the VBA window.
6) Now save the new file with the extension XLSM (Macro enabled workbook)
Hope my instruction is clear.
Merry Christmas.
Sunny
March 10, 2016
Offline
The answer is well explained !!
Thank you very much!
You helped me very much !!
March 10, 2016
Offline
I turned the function on a list of 2000 data
And it took the computer 5 minutes to give the answer
Is this how it should be? Or is there a way for your computer to run faster?
VIP
Trusted Members
June 25, 2016
Offline
Hi Lea
Custom functions will definitely perform slower than Excel functions.
I think 5 minutes is fair (fast enough for me) as the function needs to do a lot of logical comparison (not easy to do). Go get a cup of coffee in the mean time
Sunny
1 Guest(s)
