| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Help with return values on IF/THEN | Excel Discussion (Misc queries) | |||
| How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
Linear Mode
