Hi Lea,

It's written in something else than English? Can't read it, can't help you.

Sorry!

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/excel-questions/195635-fuzzy-matching-new-version-plus-explanation.html

It is very good and should do what you are asking for.

Hope this helps.

Sunny

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!!

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

The answer is well explained !!
Thank you very much!
You helped me very much !!

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?

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