Partial match

Vydeesh — Thu, 16 Dec 2021 16:34:21 GMT

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

topic Partial match in Search the Community

Partial match