Data Validation List

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top