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

Tab B
    Country           Country Currency Dode      Match?
United States             USD                                            Yes
Who is Participating?
barry houdiniConnect With a Mentor Commented:
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
barry houdiniCommented:
Try this formula in C2 of worksheet B


This will work in Excel 2007 or later versions

regards, barry
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
ConernestoAuthor Commented:
You were right. Thank you for sending the formula in an attachment.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.