Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi there. I want to extract an information with base on 2 columns, like the
example below: SHEET_1 SHEET_2 A B C D A B C D 1 ee 01 06 11 1 dd 04 09 14 ----- pick-list on "A1" 2 oo 02 07 12 2 3 uu 03 08 13 3 4 dd 04 09 14 4 5 gg 05 10 15 5 I have in sheet_2 the info on "A1" by validation list (ee; oo; uu; dd; gg) and when I choose one of that values with a pick-list, for example "dd" give me the rest (04, 09, 14) to the next cells in that sheet (B1, C1, D1). Is it possible? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get a Data validation list to select another validation l | New Users to Excel | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
Multiple Data Validation Criterias | Excel Worksheet Functions |