Partial match

[Vydeesh]

Hi,

I want to fetch a partial match from a column with its corresponding row items, with reference from other file.

Ex :

I want to get the partial match from table 1 with reference to table 2. i.e , all the line items having "cash" from table 1 should b in my o/p, similarly for multiple cases.. this is not possible with vlookup.. 

Table 1                                   Table 2

Cash sales67                       cash

Private indivi.                     Private

Private individual.            Consumer

Cash sales62739.               

Abc LLC

Jake