Data Validation & Drop-Down Lists

[crashing1912]

Hi All,

I have a drop-down data validation question. I have 5 columns that users are required to fill out when adding a new row. I'd like the help the users by adding drop-boxes that will narrow the choices down for them and reduce inaccurate mapping. I've figured out how to have dependent lists, which would work if the user always started in column A. However, the user may only know the Department Name and need to work backwards filling in columns E-A.

Here's an example set.

BU	OU #	OU Name	Dept #	Dept Name
20000	20750	Digital	920	Analytics
20000	20625	MSU	924	Finance
23000	20200	LM	900	Human Resources

<tbody>
</tbody>

Thanks!

 

[easy2understandexcel]

To give you two ideas:
1. you could use VBA code to set the value that the dropdown lists are filtered by to the active cell's row of values that are already entered.
OR
2. you could make the dynamic lists source stored within each row horizontally.