Help matching new columns with slightly different text

[chummychap]

Available grants	Published
Measuring productivity	Services Data Set
Census data	Data Security
Activity data	Monthly analysis on last census
Work Assessment	Organisation Reference Data
Smoking habits of adults	Adult smoking
Risk management	Management of risk in finance

<colgroup><col><col></colgroup><tbody>
</tbody>

Hi all,

I have searched on here and online but can't find an answer. I have created an example above. Basically, I want to compare two columns but with slightly different words e.g risk management vs management of risk in finance.

What I have tried :

(1)

=IFERROR(INDEX($B$2:$B$1375,MATCH(1,COUNTIF(A2,"*"&$B$2:$B$1375&"*"),0)),"")

but it gives a different result when I do =IFERROR(INDEX($A$2:$A$1375,MATCH(1,COUNTIF(B4,"*"&$A$2:$A$1375&"*"),0)),"")


(2)

=VLOOKUP(B2,$A$2:$A$375,1,TRUE)

which returned almost all the cells but without really matching it.


(3)

LOOKUP(2^15,SEARCH(B2,descriptions),$B$2:$B$1323)



The text above is made up but I hope it conveys my question. The column numbers are also different so I filled in random text just to use the index and match

Thank you all for your help.