Microsoft Office Forums - View Single Post - VLOOKUP to identify if a coutnry is in the EU or not

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

NoSparks uses Windows 10

Windows 10 NoSparks uses Office 2010

NoSparks uses Office 2010

Office 2010

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 831

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

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