If there is a part of a field you can search for in the other sheet,
you can use the SEARCH function which lets you find a portion of a
string with in another and use wild characters...