Text match between two column [Solved/Closed]

Report
-
 Blocked Profile -
Hello,
I have an Excel spreadsheet where I want to compare "Text" between two columns and return the value to the next column say "Match" or "Not Match" ( Example:if both column contain the same text, column A has text "LAMP" and column B has text "LAMP QUARTZ BULB 28VOLT 150WA" )

Column:
'A' 'B' 'C'
'HOUSING' 'MODULE HOUSING' 'Match'
'LAMP' 'LAMP QUARTZ 28VOLT' 'Match'
'DISCHARG' 'TIP RETAINER' 'No Match'
'CONDUCTIVE ADHSV' 'CONDUCTIVE' 'Match'
'DISCHARGER-STATIC' 'NULL FIELD TIP DISCHARGER' 'Match'



1 reply


Dear Moe,

Please have the solution from the following address.

https://ccm.net/faq/6461-excel-comparing-two-columns-a-b

Thanks.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!