Partial Matching

[K H Basavaraj]

Dear Team,

In the attachment i have shared In A Column i have specified some set of Values In the D column i have the data If the D column partially Value matches with my A column Values then i should get O/P has Done otherwise i should get Not Proper. Request you to kindly help.
Find the Attachment.

 

[shrivallabha]

Please see if the following formula does what you need:
=IF(ISNUMBER(LOOKUP(99,SEARCH(" "&$A$2:$A$25&" "," "&D2&" ",1))),"Done","Not Proper")