Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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

Re: changing sheet name in vlookup formula

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

Re: changing sheet name in vlookup formula

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

Thanks. It helped a lot.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.