hello there

i wonder if anybody could help
i have a list of example below:

cell a, cell b, cell c, cell e
1 jez 1 jez
2 jack
3 john
4 jaz

i want to create a function which if i enter 1 on cell c1 then returns jez
on cell d but i want to search it through a list basicaly, if = 1 then jez,
if = 2 jack etc

your help would be much appreciate it

thanks
jez