Help with Validation Tables

[jarrowrs]

Having worked out how to create a validation table, I'm now hopin
somebody can tell me that you can change the list displayed dependin
on the results of another cell.

Like an IF formula.

Can anybody help me out please

 

[Neil]

You can use a formula in the source in data validation after selecting
Data|Validation|list.
for example
=IF(A10=1,A1:A5,B1:B5)

regards
Neil

Having worked out how to create a validation table, I'm now hoping
somebody can tell me that you can change the list displayed depending
on the results of another cell.

Like an IF formula.

Can anybody help me out please?


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[Debra Dalgleish]

There are instructions here for creating dependent data validation lists:

http://www.contextures.com/xlDataVal02.html