Conditional Lists

  • Thread starter Thread starter cardosol
  • Start date Start date
C

cardosol

Hi,

I have a spreadsheet where I am tracking expenses. I have several
catagories of expenses, like Telephone, Utlities, etc. I want to create two
lists, one for the type of expense and the other for the vendor of the
expense. How can I create the second list to populate based on the first list
selection.

For example, if I am doing a list for telephone vendors, I select my first
list to Say Telephone and the second list to populate Verizon, AT&T, Qwest,
Sprint or if I am doing it for utlities for my first list to populate
Utlities and the second list to populate Power, Water, Trash?
 
Hi,

I have a spreadsheet where I am tracking expenses.  I have several
catagories of expenses, like Telephone, Utlities, etc.  I want to createtwo
lists, one for the type of expense and the other for the vendor of the
expense. How can I create the second list to populate based on the first list
selection.

For example, if I am doing a list for telephone vendors, I select my first
list to Say Telephone and the second list to populate Verizon, AT&T, Qwest,
Sprint or if I am doing it for utlities for my first list to populate
Utlities and the second list to populate Power, Water, Trash?
Click to expand...

Go to data/validation\ select list. then in the source range just
write an IF statment. If(X = telephone , then chose this list, if not
then chose another list or write another if statement. If you write
where the information is found, someone could help you write it.

Jay
 
How do I copy the validation to another range of cells. when I do a copy
paste special, the formula does not work right, it references the cells
above.
 
Back
Top