#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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") |
#4
|
||||
|
||||
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 |
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 |
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 |
How to identify the paragraph number you are on | SaneMan | Word VBA | 1 | 05-18-2011 05:43 AM |