return values

[jaz]

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

 

[T. Valko]

Try one of these:

=VLOOKUP(C1,A1:B4,2,0)

=INDEX(B1:B4,C1)

 

[Ragdyer]

One way:

=CHOOSE(C1,"jez","jack","john","jaz")