need formula or vba to find exact string through list and find exact correct string

Dear experts

i want formula for matching exact string value from master list i am problem like wasting time by searching one by one.

the search look up value is not complete one like half string which is right of text or left of text. look at exact string match after first space.



for E.G lookup value DRDO India OSSI Prim it has to search with exact of India OSSI Primary

find the attachment

Regards
john