Thread: VLOOKUP to identify if a coutnry is in the EU or not
View Single Post
 
Old 08-24-2021, 10:02 AM
NoSparks NoSparks is offline Windows 10 Office 2010
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
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