Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation cell entries (Drop-down list)
Hi,
I need to use a drop-down list in a range of cells of 2 columns. In the range of the 1st column, I'm using a simple data validation list for it's entries, but in the 2nd column, I need to get a list with some conditions. For example: If A1= Costs B1 only can be ('aaa', 'bbb' or 'ddd') If A1= Income B1 only can be ('ccc', 'eee' or 'fff') At the moment, at the Data Validation Settings (Source:), I'm using IF conditions, but the formula is getting too large (and I need to insert more conditions), I've tried to use SUMPRODUCT but it gives me an error! Can you help me? Thanks Nuno Belo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create list of unique entries for use in validation | Excel Worksheet Functions | |||
BUG? : data validation in-cell drop down list is not displaying | Excel Discussion (Misc queries) | |||
View all entries in Validation List | Excel Discussion (Misc queries) | |||
blank entries in data validation list | Excel Worksheet Functions | |||
Default Cell Value with Validation Drop-Down List | Excel Discussion (Misc queries) |