Excel autofill different texts

Forgive me if i am wrong but I think you are looking for the vlookup() formula.

You first create a list in a tabel like

A             B

1  code     value

2  1             one

3   2             two

4   test        example

Then use that as a reference to that vlookup function

like

       D

1     2        vlookup(D1,$A$1:$B$4,2,0) (Which will result in "two")

regards

Ahmad607577 

First, you have to inform Excel where it finds specific value related to code. By default Excel has no idea how your codes are linked with values and which ones. As variant that could be some table/range with values for each code. Could be other logic, depends on your data.

With that Excel could lookup entered code in such range and return related value. There are few functions in Excel which could do that.