MrExcel Publishing
Your One Stop for Excel Tips & Solutions

changing sheet name in vlookup formula


Posted by Steve on September 14, 2001 1:17 PM

I have two drop down boxes on a sheet. The first one selects an employER from a list on another sheet while the second one (should) selects an employEE from a sheet based on which employER is selected. Each employER has its own sheet. How can I have the second drop down box only pick from the employER selected in the first drop down box?

Thanks for any help


Posted by IML on September 14, 2001 1:32 PM

First, create names for your employee lists that match the employer name that will be entered.
For example, if all employees of ACME are in column A of a sheet have the name ACME refer to A:A on that sheet. Repeat for all employers.


Then for your validation of the employee cell to allow for a list. Under the source box, put =indirect(A1), where A1 is where your user selected the company.

Good luck

Posted by Steve on September 14, 2001 8:04 PM

Thanks. It helped a lot.