Make your formula something like=if(Vlookup(A5,Master!A1:P9999,3,false)=0,"Nil",Vlookup(A5,Master!A1:P9999,3,false))