On Apr 28, 11:56*am, cardosol
wrote:
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?

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