|If you have data like this, then an IF statement should work for you:|
1 CLUB MEMBER
2 CLUB MEMBER
3 CLUB STATION
4 NO CLUB
5 CLUB STATION
Put this in B1 and drag it down.
=IF(A1="CLUB MEMBER",50,IF(A1="CLUB STATION",40,30))
If that is not what you are looking for, please provide some more details.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.