EE-Match.xlsx

<div>
Maybe this...<br />
<br />
In C2<br />

<pre><code class="code-1 nolinks" id="code-20-42095462-1"><span>=IF(COUNTIF($B$2:$B$5,A2),&quot;Match&quot;,&quot;No Match&quot;)</span>
</code></pre>
and copy it down.<br />
Change the range reference as per your requirement.
</div>


<div>
The formula did not work. I have about 436 rows in column A and 3807 rows in column B. For example in column A I have a Software name that says Microsoft Visio 2013 Professional. In Column B I have Microsoft Visio 2010 STD and Microsoft Visio 2016 Professional. The common element is Visio which is available in A and B. So Visio is a match. I need to do the same for all the rows in A and match it with B (Not exact Match) and have the result output in C saying if there was a match or not.
</div>


<div>
We are not aware of the data what you have on the sheet. You asked a very general question. It would be better if you upload a sample workbook with small set of dummy data and mock up the desired output manually.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a Column B which is a master list of Software. I have a column A which is another Set of Software list. I need to compare the text in Column A rowl 1 with entire Column B and return a Match no Match status in Column C. Then pickup row2 in column A and compare with Column B.This has to be done for all the rows in Column A with that of Column B.
</div>
</div>


Hello,

I have a Column B which is a master list of Software. I have a column A which is another Set of Software list. I need to compare the text in Column A rowl 1 with entire Column B and return a Match no Match status in Column C. Then pickup row2 in column A and compare with Column B.This has to be done for all the rows in Column A with that of Column B.

Excel compare strings

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.