try This..

Formula: copy to clipboard
=LOOKUP(A1,{0;334;667},{1;2;3})


Ottawa... I hope.. no need to swap ";" and "," but if doesn't work.. then swap as suggested..