using application.match to same cell

[ash3angel]

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

[NeedForExcel]

Assuming you will type a number in Cell A1, put this in Cell B1
=VLOOKUP(A1,$C$1:$D$4,2,0)

[ash3angel]

thanks for ur reply, i want it in vba using application.match if i write number 1 to 10 it will automatically become the letters when i run the macri