• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

LookupValue

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
0
Conernesto
Asked:
Conernesto
  • 2
  • 2
1 Solution
 
barry houdiniCommented:
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
0
 
ConernestoAuthor Commented:
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
0
 
barry houdiniCommented:
I'm not sure why you don't think it will work, it works for me, see attached - formula in yellow highlighted cells

regards, barry
Matches.xlsx
0
 
ConernestoAuthor Commented:
You were right. Thank you for sending the formula in an attachment.

conernesto
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now