Need a formula to cross search two tables using a string

[shivakanou]

Hello everybody!

I need help with making a formula where I'll input one string from Table A and I'll return me the code from Table B that has the same string from Table A, let me explain:

I have two tables, Table A has a code and a simple description, like "describes employees", table B also has a code, but it's different from Table A's and the "same" description but bigger, like "describes employees that work here".
What I need to do is get the description from Table A "describes employees", do a search on Table B with it and return me the code, example:

Table A
codFun - describes employees

Table B
matEmp - describes employees that work here

Result expected:
(search) describes employees
codFun - matEmp - describes employees that work here

I'm trying to do this using FIND and MATCH, but it's only returning me the amount of cells that has similar values (usually 1).

Does anybody knows if it's possible and how to make this formula?

Thank you!

 

[sanrv1f]

Assuming Table A is in A1:B10, Table 2, is in D1:E10,

=INDEX(A1:A10,MATCH("*"&E1&"*",B1:B10,0))

 

[shivakanou]

Assuming Table A is in A1:B10, Table 2, is in D1:E10,

=INDEX(A1:A10,MATCH("*"&E1&"*",B1:B10,0))

Awesome, thanks!

But, what if the phrase is a little bit different?

Example:
Table A - employee's e-mail contact
Table B - employee's e-mail

Because it's searching for "employee's e-mail contact" it didn't return the code corresponding to "employee's e-mail".

Is there a way to solve this?

Thank you!

 

[sanrv1f]

Have a look at Fuzzy lookup here

 

[shivakanou]

Have a look at Fuzzy lookup here

Thanks Sankar!
One thing, I'm facing this issue here:

Above it I have the exact same case and it's working fine, do you have any idea what could be the problem?

Thank you