Required Vlookup / Index / vba code for bring party id

[sbvaram]

Dear All,

i want bring party id for using vlookup / index / vba code..
but In the second list, the name of the party is incomplete.
can possible using vlookup / index / vba code ?
attached pic & xls. file

help me please..

for party id.png

[PaulM100]

Try this: =INDEX($A$3:$A$7,MATCH("*"&D3&"*",$B$3:$B$7,0))

[sbvaram]

Yesss Correct sir,
I got what i wanted.

Thank u Very much sir,

[PaulM100]

You are welcome.