excel search engine

in reference to pete's solution to a search engine excel :

Reference: http://www.excelforum.com/excel-gene...readsheet.html

is there any way to allow the search to run through the entire cell rather than only by the LEFT?

e.g :
1) P_code is BS31
2) in my search field, if i only type S3 , the data will also populate.

ef209_matrix new.xlsx

You can write *s3* to match "BS31"
Is this what you intended?