Solved

LookupValue

Posted on 2014-01-04
4
164 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
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…

762 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now