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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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

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" wrote in message
...

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?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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

There are instructions here for creating dependent data validation lists:

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

jarrowrs wrote:
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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html