+ Reply to Thread
Results 1 to 7 of 7

VLOOKUP to identify if a coutnry is in the EU or not

  1. 08-24-2021, 07:21 AM #1
    Abbiew1
    Abbiew1 is offline
    Registered User
    Join Date
    08-24-2021
    Location
    London
    MS-Off Ver
    2016
    Posts
    2

    VLOOKUP to identify if a coutnry is in the EU or not

    Hello.

    I am trying to do a V look up with some of the following countries:

    United Kingdom
    Germany
    United Arab Emirates
    France
    Finland
    Italy
    Russia
    Belgium
    Ireland
    Spain
    USA
    Norway
    Sweden
    Mexico
    Singapore
    Australia
    Turkey
    Lithuania
    Greece
    Netherlands
    Northern Ireland

    and want to do a VLOOKUP to confirm whether the country is in the EU or not?

    thanks
    Abbie
    Reply With QuoteRegister To Reply
  2. 08-24-2021, 07:26 AM #2
    Limor_OP
    Limor_OP is offline
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: VLOOKUP to identify if a coutnry is in the EU or not

    First categorize them EU/NONE-EU in the next adjecent column -
    then you can do the vlookup.

    =VLOOKUP(D4,A:B,2,0)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 08-24-2021, 07:46 AM #3
    Abbiew1
    Abbiew1 is offline
    Registered User
    Join Date
    08-24-2021
    Location
    London
    MS-Off Ver
    2016
    Posts
    2

    Re: VLOOKUP to identify if a coutnry is in the EU or not

    Thanks.

    so I have all of these countries listed in column A:

    United Kingdom
    Germany
    United Arab Emirates
    France
    Finland
    Italy
    Russia
    Belgium
    Ireland
    Spain
    USA
    Norway
    Sweden
    Mexico
    Singapore
    Australia
    Turkey
    Lithuania
    Greece
    Netherlands
    Northern Ireland
    -
    Austria
    Switzerland
    Denmark
    Estonia
    Croatia
    Taiwan
    Jersey
    Latvia
    Serbia
    Cyprus
    South Africa
    Bulgaria
    Armenia
    Poland
    Hungary
    China
    Romania
    Gree ce
    Hong Kong
    Slovakia
    India
    Reunion
    Portugal
    Ukraine
    Czech Republic
    Malta

    Bosnia and Herzegovina
    Brazil
    Guernsey
    Jamaica
    Japan
    Luxembourg
    New Zealand
    Slovenia
    Uruguay

    and I need to use column E to do a VLOOKUP to identify if the country is in the EU or not. but not sure how to do that.

    thanks
    abbie
    Reply With QuoteRegister To Reply
  4. 08-24-2021, 08:20 AM #4
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,147

    Re: VLOOKUP to identify if a coutnry is in the EU or not

    See post #2

    In column B you need to add (as Belinda's example) "EU" or "Non-"EU": there is no other way of identifying EU countries.

    Table here

    https://europa.eu/european-union/about-eu/countries_en
    Reply With QuoteRegister To Reply
  5. 08-24-2021, 09:15 AM #5
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,857

    Re: VLOOKUP to identify if a coutnry is in the EU or not

    crossposted: https://www.mrexcel.com/board/thread...r-not.1179943/

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Read this to understand why we ask you to do this.

    I have added the crosspost reference for you today. Please comply with this and all our rules in the future
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  6. 08-28-2021, 05:02 PM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: VLOOKUP to identify if a coutnry is in the EU or not

    Also cross-posted here: https://www.msofficeforums.com/excel...ry-eu-not.html
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  7. 08-28-2021, 08:52 PM #7
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: VLOOKUP to identify if a coutnry is in the EU or not

    You could simplify the approach by just having a list of EU countries and then seeing if the country that you are looking for exists in the EU list. You can then use a formula with MATCH and ISNUMBER, or one with COUNTIF, so you don't have to use VLOOKUP (unless you have been told that you must use it if this is a homework question).

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Query that will identify latest record - VLookup???
    By RW68701 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-28-2015, 04:08 PM
  2. [SOLVED] Duplicates in Multiple sheets, How do I identify then using vlookup
    By markchauke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2013, 08:19 AM
  3. [SOLVED] use variable to identify file name in vlookup
    By kramtelbuab in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2013, 08:16 PM
  4. VLOOKUP help to identify a way to match the data from one spreadsheet to another
    By S ice in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-21-2012, 06:06 PM
  5. [SOLVED] Can I identify variables using VLOOKUP, and then pass variable to another VLOOKUP?
    By Jeff C in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-05-2012, 05:54 PM
  6. exact value need to identify from the Vlookup
    By Shadmani in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-20-2009, 06:09 PM
  7. How can VLOOKUP identify between multiple choices for > 1 batch?
    By Ivan Thorn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2005, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1