Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

LookupValue

Posted on 2014-01-04
4
170 Views
Last Modified: 2014-01-04
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
Comment
Question by:Conernesto
  • 2
  • 2
4 Comments
 
LVL 50

Expert Comment

by:barry houdini
ID: 39756220
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
 

Author Comment

by:Conernesto
ID: 39756262
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
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 39756499
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
 

Author Closing Comment

by:Conernesto
ID: 39756554
You were right. Thank you for sending the formula in an attachment.

conernesto
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question