Try this one

if(iserror(vlookup(Z3,W2:X13,2,FALSE)),1,Z3)

I expect it works because I use Spanish Excel and I had to look for the English formulas.