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.