| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show cell value based on list selection
I have a worksheet I created that has 2 columns column 1 has various company
names and column 2 has a generated number I formated using (Left(b2,4)&"01"). Now what I want to be able to do is when I select one of the company names from a list on another worksheet created using the validate data tool I want the contents of the cell to show the the colmn 2 value not the column 1 value. I am new to programming Excel. I am using Office Excel 2003 (11.8146.8132) SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Best method to populate cell based upon drop down list selection | Excel Discussion (Misc queries) | |||
| How to Auto-populate cell based on selection of a list item | Excel Discussion (Misc queries) | |||
| set cell values based on selection from list | Excel Programming | |||
| Setting Cell Value Based on List selection | Excel Programming | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Linear Mode
