Check value appears in table (lookup?)

[dan_manchester]

Evening guys,

Just wondering if you could help with what I am sure is an easy one...

In Column C I need a "yes" or "no" answer to if the country code in B is listed in column A. I have 700 orders from country codes and need to understand which ones I need to charge VAT.

I hope that makes sense and thanks in advance

excel3.png

[Richard Buttrey]

Hi and welcome to the forum,
C2 copied down

Please Login or Register  to view this content.

[dan_manchester]

Thanks Richard but that was giving me a "Yes" for any 2-letters in the EU field.

This function has worked (in case anyone else needs it...)

=ISNUMBER(MATCH(B2,A:A,0))+0

Positive: 1; Negative: 0.