Text encoding (converting to numeric) based on use

问题:

I have data in text form that I need to encode/convert to numeric form according to rules I defined. To clarify:

Need formula for output column so that it compares original text data with text-number encoding rules and returns numeric value of text in each row.

回答1:

Put this in C3 and drag down:

=INDEX(F$2:F$6,MATCH(A3,E$2:E$6,0))