I am stuck with finding fuzzy vertical lookup search and I also used Fuzzy lookup Add-in but its taking huge time and its hanging too as I have data around 45 lakhs Rows

Can you help me find fuzzy lookup for the below table. I want to fuzzy lookup with Column A&B with D&E and want to return the results in column G,H,I,J,K respectively.

Google Spreadsheet Link:

https://docs.google.com/spreadsheet/...laE9DSGc#gid=0

Looking forward for your prompt response and thanking you in advance.

Cheers
Kashif