Creating a list of values based off the value in another cell

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I am building a Bidding spreadsheet where I am selecting
the Name of my Customer from data validation list. That
information is in C3. In C5, I want to be able to make a
validation list of the names of the people whose company =
the value in C3.

The Company names and the peoples names are in hidden
columns in my spreadsheet.

How do I do that?

Thank you in advance
Tracy
 
If the number of companies equal 7 or less you can pretty
simply add a column containing IF statements that can be
used as the source of your data validation list of
employees matching the company chosen in your first data
validation list drop down.
For example I used 3 companies named in row 1 of Columns
A, B & C and listing their employees in the rest of the
column. In the next column (D) I used the IF statement
=IF(H$2=A$1,A2,IF(H$2=B$1,B2,IF(H$2=C$1,C2,""))) where H2
is the cell where the data validation for the companies
names resides. Fill this IF statement down to the last
row of the longest company's employee list, then set up
your second data validation list using this range of IF
statements to allow you to select an employee from the
company you selected in the first data validation drop
down list.
 
Back
Top