return values
 

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

return values
 

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

return values
 

One way:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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