column 2
=MATCH(A2,{"a","b","c","d"},0) and copy down