Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
sheet1 cell I3, I want to creat a LIST VALIDATION, when the drop down is
selected it will show sheet2 column A choices, no biggie so far, but based on the list validation choice, I want it to return the value in the corresponding row in sheet2 column b in cell I3 IE: Sheet 2 Column A Column B Hard Drive 2 Monitor 3 keyboard 4 sheet 1 cell I3 list validation shows column a choices, I select hard drive it will put a 2 in cell I3 not Hard Drive???? Also I have looked at contextures code and still cannot figure this out, please tell me what i need to put in the code list validation bax, thanks so much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
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 | |||
lookup? list data into summary table | Excel Worksheet Functions |