<div>
Try this formula in C2 of worksheet B<br />
<br />
=IF(COUNTIFS(A!A:A,A2,A!B:<wbr />B,B2)&gt;0,&quot;Y<wbr />es&quot;,&quot;No&quot;)<br />
<br />
This will work in Excel 2007 or later versions<br />
<br />
regards, barry
</div>


Try this formula in C2 of worksheet B

=IF(COUNTIFS(A!A:A,A2,A!B:B,B2)>0,"Yes","No")

This will work in Excel 2007 or later versions

regards, barry

<div>
I don't think that will work.<br />
<br />
Sample Tab A<br />
<br />
CountryA &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SGD<br />
CountryB &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USD<br />
CountryC &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USD<br />
CountryD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USD<br />
<br />
Tab B<br />
<br />
CountryA &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USD &nbsp; This one does't match tab A<br />
CountryB &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USD &nbsp; Match<br />
CountryC &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USD &nbsp; Match<br />
CountryD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USD &nbsp; Match
</div>


I don't think that will work.

Sample Tab A

CountryA      SGD
CountryB      USD
CountryC      USD
CountryD      USD

Tab B

CountryA      USD   This one does't match tab A
CountryB      USD   Match
CountryC      USD   Match
CountryD      USD   Match

Matches.xlsx

<div>
You were right. Thank you for sending the formula in an attachment.<br />
<br />
conernesto
</div>


You were right. Thank you for sending the formula in an attachment.

conernesto

<div>
<div class="content wysiwyg-content">
I have a worksheet with two spreadsheets. The spreadsheet names are Tab A and Tab B. <br />
Tab A has in column A a list of Countries and in column B the related country currency codes.<br />
Tab B also has a list of Countries and related country currency codes. On tab b column C, I want a formula that tells me if the country and country currency code in Tab A &nbsp;matches &nbsp;what is in tab B<br />
<br />
Example<br />
Tab B<br />
&nbsp; &nbsp; Country &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;Country Currency Dode &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Match?<br />
United States &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;USD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Yes
</div>
</div>


I have a worksheet with two spreadsheets. The spreadsheet names are Tab A and Tab B. 
Tab A has in column A a list of Countries and in column B the related country currency codes.
Tab B also has a list of Countries and related country currency codes. On tab b column C, I want a formula that tells me if the country and country currency code in Tab A  matches  what is in tab B

Example
Tab B
    Country	     Country Currency Dode	Match?
United States	       USD	                                      Yes

LookupValue

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.

Microsoft Office

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.