=LOOKUP(B1,{"A","D","SA","SD"},{3,2,4,1})


"EOB" wrote:

I need a formaula that says:
If Cell B1 contains SA or A or D or SD then cell C2 reads 4 for SA or 3 for
A or 2 for D or 1 for SD. I hope that makes sense. I know how to do it for
yes and no but not when the cell could have four different entries.
Thank you