Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create two validation lists that modify each other's value?
For instance, let's say I have a list containing both product numbers
and descriptions. I would like to create the following validation lists Number Description [12345] [Digital Camera XBC] Original lists: 00001 Camera 00002 Mouse .... 12345 Digital Camera XBC .... If I know the product's number, I select its number from the list on the left and it automatically changes the description. If I know the description, I select the description and it automatically changes the product's number. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create two validation lists that modify each other's value?
You could use a Vlookup to do one or the other, but you can't have both a
formula and a value in a cell. You would need to use the Worksheet_Change Event to lookup the value you don't enter. In Excel 97, selection of a value from a data validation dropdown does not fire the change event, so this wouldn't work in xl97. -- Regards, Tom Ogilvy "Chracatoa" wrote in message om... For instance, let's say I have a list containing both product numbers and descriptions. I would like to create the following validation lists Number Description [12345] [Digital Camera XBC] Original lists: 00001 Camera 00002 Mouse ... 12345 Digital Camera XBC ... If I know the product's number, I select its number from the list on the left and it automatically changes the description. If I know the description, I select the description and it automatically changes the product's number. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create two Data validation lists that are linked(Both change toget | Excel Worksheet Functions | |||
Excel -- Data Validation -- Create Dependent Lists | Excel Worksheet Functions | |||
How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
How to create Dropdown lists not using Data Validation | Excel Discussion (Misc queries) | |||
Data Validation - Create dependent lists | Excel Discussion (Misc queries) |