Try one of these:

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

=INDEX(B1:B4,C1)

--
Biff
Microsoft Excel MVP


"jaz" wrote in message
...
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