?
Solved

LookupValue

Posted on 2014-01-04
4
Medium Priority
?
179 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
[X]
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
  • 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 2000 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
New style of hardware planning for Microsoft Exchange server.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

765 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