Assuming your text/code table is in columns A & B (A2:B8)and C2 contains
value to be converted:

=VLOOKUP(C2,$A$2:$B$8,2,0)

"ramon" wrote:

I need to convert a list of text values and assign a number code
example:
Text Value Code
A- 7
A 6
A+ 5
AA- 4
AA 3
AA+ 2
AAA 1