Excel Drop Down Menu Work

[jmorovich]

I have an Excel sheet that I want to simplify for my users. I want to give them the ability to select data from a drop down and have the sheet prefill other columns based on their dropdown selection. I'm ok with the drop down part. I'm having trouble figuring out the next 2 steps. I have a sheet that has a workers title (HR Admin, accountant, I/T, etc). Each title has an associated code (ex 1234). So it's not possible to have the user memorize the code which is needed for billing purposes. They also have a billing rate associated with their title and code.
So I now have a sheet (used for the dropdown menu) with 3 columns (Title, Code, & Rate). I want the drop down list to show their title, however when they select that title the code associated with that title fills the column (not the title) and the rate tied to that code fills the adjacent column in the spreadsheet.
Am I asking too much of Excel? If not can someone help me figure out how to get this to happen?

Thanks in advance.

[NBVC]

I think you would need to use VLOOKUP() function.

Set up a table somewhere with the Title and associated Codes and Rates.

In the column next to the dropdown for Title.. enter a formula such as:

=Vlookup(A1,$X$1:$Z$100,2,0) to extract the Codes

where A1 contains the Title dropdown and X1:Z100 is the table you set up with Titles in column X.

In the next column you would have something like:

=Vlookup(A1,$X$1:$Z$100,3,0) to extract the Rates.

[VBA Noob]

jmorovich,

Please read the forum rules below and then add the link to the other forum that you have posted the same question.

To understand why we ask you to do this read the message to cross posters also below

VBA Noob

[NBVC]

Well, at least I pretty much gave the same answer...