Excel 2007 : How to combine vlookup and search partial text

[belebala]

Hello All,

I want to create a formular to return a value by searching a partial text. For example, in Sheet 2 col B, I want to search Sheet 2 col A (ID001) from the partial text of Sheet 1 Col A (ID001 - Name 1) and return the value of Sheet 1 Col B to Sheet 2 Col B (Yes).

Sheet 1:
Col A Col B
ID001 - Name 1 Yes
ID002 - Name 2 No
ID003 - Name 3 No

Sheet 2:
Col A Col B
ID001 [Return Value]
ID003 [Return Value]

Thanks for your help in advance.