Help with Validation Tables

J

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
 
N

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
jarrowrs said:
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?
Click to expand...
creating financial statements
 
Top