Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-24-2021, 03:09 AM
AbbieW1 AbbieW1 is offline VLOOKUP to identify if a coutnry is in the EU or not Windows 10 VLOOKUP to identify if a coutnry is in the EU or not Office 2016
Novice
VLOOKUP to identify if a coutnry is in the EU or not
 
Join Date: Aug 2021
Posts: 1
AbbieW1 is on a distinguished road
Default 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 Quote
  #2  
Old 08-24-2021, 09:43 AM
wiganken wiganken is offline VLOOKUP to identify if a coutnry is in the EU or not Windows 10 VLOOKUP to identify if a coutnry is in the EU or not Office 2019
Competent Performer
 
Join Date: Jul 2018
Posts: 121
wiganken will become famous soon enough
Default

I thought it only worked for content within the current spreadsheet although I could be wrong. See Video: VLOOKUP - When and how to use it - Excel

I don't think it works for searching the internet to see if a country is in the EU or not.
Reply With Quote
  #3  
Old 08-24-2021, 10:02 AM
NoSparks NoSparks is offline VLOOKUP to identify if a coutnry is in the EU or not Windows 10 VLOOKUP to identify if a coutnry is in the EU or not Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 811
NoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the rough
Default

As suggested at MrE after the OP supplied enough information to know what they were working with

=IF(ISNA(MATCH(A3,$I$4:$I$23,0)),"Non-EU","EU")
Reply With Quote
  #4  
Old 08-28-2021, 01:24 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline VLOOKUP to identify if a coutnry is in the EU or not Windows 7 64bit VLOOKUP to identify if a coutnry is in the EU or not Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,480
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Cross post VLOOKUP to identify if a coutnry is in the EU or not | MrExcel Message Board
and
VLOOKUP to identify if a coutnry is in the EU or not
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tell me which place the vlookup was successful (within a nested vlookup) Izzii0x Excel 2 07-18-2019 10:29 PM
How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array EcommDOC Excel 7 01-22-2018 11:00 AM
VLOOKUP to identify if a coutnry is in the EU or not Please help me Identify this font!!! PLEASE!!! krammkracker Word 1 10-13-2015 12:06 PM
VBA to identify how Word was invoked Sorcerer13 Word VBA 7 04-24-2014 11:15 AM
VLOOKUP to identify if a coutnry is in the EU or not How to identify the paragraph number you are on SaneMan Word VBA 1 05-18-2011 05:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft