VLOOKUP - search only one word from long text & write

Attached is the mock excel spreadsheet.

I want to read "sam" from the lookup column's long text "sam is good" and then write "4" in the next column. Similarly read "white" from the long text "white is tired" and write "1". And so on,,,,, For more criteria, see box highlighted in yellow,,,,I used VLOOKUP but what am able to make it work only when there is one word "sam" in the lookup column. It returns #NA when the text is "sam is good". It should write nothing if none of the criteria is met and should keep doing until the last cell in the lookup column.

I will appreciate your help.
Thx.

One route might be:

B7: =INDEX($E$2:$E$5,MATCH(TRUE,INDEX(ISNUMBER(SEARCH($D$2:$D$5,$A7)),0),0))
copied down

It will return the first match should multiple matches exist in any given string, error if not.

If you wished to aggregate in cases of multiple keyword match then you could use a SUMPRODUCT approach.

B7: =SUMPRODUCT(--ISNUMBER(SEARCH($D$2:$D$5,$A7)),$E$2:$E$5)
copied down

Just noticed... if the intention is only to search based on first word of long string then things are simplified somewhat:

=VLOOKUP(LEFT(A7,FIND(" ",A7&" ")-1),$D$2:$E$5,2,0)