Data Validation List

[Guest]

Is it possible to have 2 validation list dependent upon the entry of another cell
Example
A1 =Cat or Dog Validation list= B1:B1
A1=Car or Truck Validation List =B11:B1

Thanks in advanc
Ada

 

[Don Guillett]

Debra will be along soon to help you. If not,
Debra Dalgleish

 

[Frank Kabel]

Hi Adam
try the following
1. Create a defined name (goto 'Insert - Name - Define Name') an enter
the following formula 8lets say for the name list9:
list: =OFFSET($B$1:$B10,--($A$1="Car or Truck")*10,0)

2. For your validation enter the following formula in the data
validation dialog:
=list

Frank

 

[Guest]

OK I have the basics working following that link. Here are the details...I have several different transactions types that fall into either Firm or NonFirm classification, with different providers for each. I have the Trasnaction Type in A4 and the Provider in A5. I want the list of nonfirm providers to show up when the nonfirm transactions are selected and likewise for the firm. It seems as though I may need a look between Type and Classification in order to make it work
Suggestions???
Thanks