| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I pick value A from a list and have excel return value B?
I have a list of 30 names that have coded values. Since nobody has memorized
the coded values, I'd like the list to have the names and when you select the name it displays the coded value. Example: Column 1 A 'Monkey' (is on the list, but monkey is really 185.54) When you pick Monkey from the list I would like the display to look like this: Column 1 A 185.54 Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I pick value A from a list and have excel return value B?
How about creating a list on a different sheet (say sheet2), then use an
adjacent cell to return the numeric value for that name: In B1: =if(a1="","Pick a name",vlookup(a1,sheet2!a:b,2,false)) or =if(a1="","",vlookup(a1,sheet2!a:b,2,false)) You could even hide the column with this formula, but still use that cell in any subsequent calculations. Jim wrote: I have a list of 30 names that have coded values. Since nobody has memorized the coded values, I'd like the list to have the names and when you select the name it displays the coded value. Example: Column 1 A 'Monkey' (is on the list, but monkey is really 185.54) When you pick Monkey from the list I would like the display to look like this: Column 1 A 185.54 Any ideas? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I pick value A from a list and have excel return value
Briliant, thank you Dave.
"Dave Peterson" wrote: How about creating a list on a different sheet (say sheet2), then use an adjacent cell to return the numeric value for that name: In B1: =if(a1="","Pick a name",vlookup(a1,sheet2!a:b,2,false)) or =if(a1="","",vlookup(a1,sheet2!a:b,2,false)) You could even hide the column with this formula, but still use that cell in any subsequent calculations. Jim wrote: I have a list of 30 names that have coded values. Since nobody has memorized the coded values, I'd like the list to have the names and when you select the name it displays the coded value. Example: Column 1 A 'Monkey' (is on the list, but monkey is really 185.54) When you pick Monkey from the list I would like the display to look like this: Column 1 A 185.54 Any ideas? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| Create a pick list to use to go to a text cell in Excel | Excel Worksheet Functions | |||
| How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
| In which menu can I find the "pick from list" feature in Excel? | Excel Discussion (Misc queries) | |||
| How do I pick a number from a list in Excel? | Excel Worksheet Functions | |||
Hybrid Mode
