Text match between two column

Solved/Closed
Moe - Jul 25, 2010 at 12:57 AM
 Blocked Profile - Jul 25, 2010 at 03:51 AM
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

Blocked Profile
Jul 25, 2010 at 03:51 AM
Dear Moe,

Please have the solution from the following address.

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

Thanks.
0