# Data Validation - Conditional List Boxes

Posted by Jeremy on January 05, 2001 12:47 PM

This is an addendum to my original post (located below).

The list box is partially working. The problem is that the Department Numbers are formatted as follows:

1 - Finance

2 - Sales

For some reason, the formula I was given (from this site) doesn't recognize text....only numbers. Is there a way around this?

Thanks,

Jeremy

Here's the data:

I have a list of department numbers (1-44) and within each department number are numerous unit numbers. For instance, Department 1 is made up of unit numbers 70 - 300 (the unit numbers are listed in 10's; i.e., 70, 90, 120, etc).

Here's the question:

I have already created a list box using Data Validation that lists all the department numbers. Now, I the Unit Number list box to only list the unit numbers that correspond to a particular department. For example, if the user selects department 1, then I want the unit number list box to only list the units that are associated with Department 1. Currently, my list box contains EVERY unit in our company.