i have set of data in column c & d sample

c d

1 A
2 B
3 C
4 D

i want to have this in column A whenever i typed the number in column A number will match to the coresponding lettter

thanks