| Home |
| Search |
| Today's Posts |
|
#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) |
| 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 | |||
Threaded Mode
