Partial data match from ColumnA and ColumnB in columnC

[satish78]

Hi friends,

Trying to do partial data match of ColumnA and ColumnB in ColumnC for example

Here is the sample file with result and highlighted what text have to be partial match.

I am not good in VBA macros. Tought that it is only possible VBA macro.

https://spaces.hightail.com/space/Gf86h0pqLW

 

[wideboydixon]

Try this in E1 and copy down:

=IF(AND(ISNUMBER(SEARCH(SUBSTITUTE(A1," ",""),SUBSTITUTE(SUBSTITUTE(C1," ",""),CHAR(10),""))),ISNUMBER(SEARCH(SUBSTITUTE(B1," ",""),SUBSTITUTE(SUBSTITUTE(C1," ",""),CHAR(10),"")))),"Yes","No")

WBD

 

[satish78]

Worked like charm.

Thanks Dixon

 

[satish78]

Is it also possible to extract information between text from location and area like from

Wayne Brent (retired) Associate Director, Evaluation Services at The University of Arizona. Location Tucson, Arizona Area Industry Higher Education

 

[wideboydixon]

Not sure. What is in columns A/B/C for this one?

WBD

 

[satish78]

Not sure. What is in columns A/B/C for this one?

WBD

Same data and sample file on this post.

 

[wideboydixon]

Hi,

I don't think that's possible using a formula. It looks like it needs some extra information. I didn't see this data in your original sheet.

WBD