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
