Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation with formulas
I use to think I knowe a lot about Excel - but as people ask "can you do
this?" I dont know as much as I though In the valiation source - can a formula be entered i.e. =($E4="Books","NA",=INDIRECT($E4)) Becky |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation with formulas
Did you try it out?
Answer is "Yes". However formula should evaluate to a result which can be used as a List. EXample: =IF(D1=0,List1,List2) You can also use =IF($E4="Books",$E$5,INDIRECT(A1)) With A1 containing name of a list and E5 equal to NA. I use =INDIRECT(A1) a lot for dependent lists... "MarsBars" wrote: I use to think I knowe a lot about Excel - but as people ask "can you do this?" I dont know as much as I though In the valiation source - can a formula be entered i.e. =($E4="Books","NA",=INDIRECT($E4)) Becky |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation formulas | Excel Discussion (Misc queries) | |||
formulas/data validation | Excel Worksheet Functions | |||
Data Validation formulas | Excel Discussion (Misc queries) | |||
How to use validation formulas in Combobox | Excel Discussion (Misc queries) | |||
validation formulas | Excel Worksheet Functions |