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

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.

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")

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