| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation
I have two colums
SYMBOL NUMBER O 16 H 1 C 12 When i do a Dropdown list of symbols on another sheet how do i populate the corresponding data so that I pick any from Symbol and the number pops up next to it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation
Watch this 5 min video:
How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM And then see this on how to get the result your after: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "K2hunter" wrote in message ... I have two colums SYMBOL NUMBER O 16 H 1 C 12 When i do a Dropdown list of symbols on another sheet how do i populate the corresponding data so that I pick any from Symbol and the number pops up next to it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data Validation Update Validation Selection | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Linear Mode
