Codes for same column with index and match function looping

Please help me coding index and match in same columng.

sample

i have this in column C and D
1 A
2 B
3 C
4 D
5 E

and i want to have a macro code whichever i write something in column A result will be across

result
Column A

1 = A
3 = C

Thanks