Help matching new columns with slightly different text

[chummychap]

[TABLE="width: 1106"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Available grants[/TD]
[TD]Published[/TD]
[/TR]
[TR]
[TD]Measuring productivity[/TD]
[TD]Services Data Set[/TD]
[/TR]
[TR]
[TD]Census data[/TD]
[TD]Data Security [/TD]
[/TR]
[TR]
[TD]Activity data[/TD]
[TD]Monthly analysis on last census[/TD]
[/TR]
[TR]
[TD]Work Assessment [/TD]
[TD]Organisation Reference Data [/TD]
[/TR]
[TR]
[TD]Smoking habits of adults[/TD]
[TD]Adult smoking [/TD]
[/TR]
[TR]
[TD]Risk management[/TD]
[TD]Management of risk in finance

[/TD]
[/TR]
</tbody>[/TABLE]

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.