Can someone please tell me if this is possible?

What I want to do is have a drop-down list, but when you choose a value from
the list, it inputs the value from another list.

for example, if I have the two lists from columns B and C, can I have the
drop-down list have the values in column B, but when you choose the value, it
inputs the value from column C?

If I choose 3 from the drop-down list, I want it to show C in the cell.

A B C
1 1 A
2 2 B
3 3 C


Thanks!