Help with Validation Tables

  • Thread starter Thread starter jarrowrs
  • Start date Start date
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
 
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?


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



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top