| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i get 1 value to display another value when selected
In my excel worksheet i have a drop down menu that displays codes, but i also
have the meaning of that code in another column. I want to be able to select the from the drop down and it shows the correlating definition in the adjacent cell. any clue on what formula can do this. thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can i get 1 value to display another value when selected
Six Sigma Blackbelt wrote:
In my excel worksheet i have a drop down menu that displays codes, but i also have the meaning of that code in another column. I want to be able to select the from the drop down and it shows the correlating definition in the adjacent cell. any clue on what formula can do this. thank you Assuming your codes are in A1:A10 and your meanings are in B1:B10 and the drop down is in C1 put the following in D1: =VLOOKUP(C1,A1:B10,2,FALSE) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can i get 1 value to display another value when selected
Thanks Glenn, this will start me off, the codes & definitions are located on
sheet 2 of the workbook, which i forgot to mention. So does that change the formula. The airport codes are in the drop down on sheet 1, below the drop down is the definition or lanes that i want to display when i pick the airport from the drop down. Thank you again Glenn "Glenn" wrote: Six Sigma Blackbelt wrote: In my excel worksheet i have a drop down menu that displays codes, but i also have the meaning of that code in another column. I want to be able to select the from the drop down and it shows the correlating definition in the adjacent cell. any clue on what formula can do this. thank you Assuming your codes are in A1:A10 and your meanings are in B1:B10 and the drop down is in C1 put the following in D1: =VLOOKUP(C1,A1:B10,2,FALSE) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can i get 1 value to display another value when selected
Six Sigma Blackbelt wrote:
Thanks Glenn, this will start me off, the codes & definitions are located on sheet 2 of the workbook, which i forgot to mention. So does that change the formula. The airport codes are in the drop down on sheet 1, below the drop down is the definition or lanes that i want to display when i pick the airport from the drop down. Thank you again Glenn Just select the range instead of typing it into the formula. Should come out something like this: =VLOOKUP(C1,Sheet2!A1:B10,2,FALSE) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Zero only in Selected Cells using a formula | Excel Worksheet Functions | |||
| What happened to the display of the total in cells selected | Excel Discussion (Misc queries) | |||
| How to display selected table entries from another worksheet? | Excel Worksheet Functions | |||
| display zero values in selected cells | Excel Discussion (Misc queries) | |||
| Display selected rows from one worksheet to another | Excel Worksheet Functions | |||
Linear Mode
