Associate data in different cells

[rderkins]

I am using Microsoft Excel 2003.
There is something I am trying to do within a workbook and cannot figure out how to do it.

On one worksheet in my workbook, I have a two-column list.
Column A contains the name of a person.
Column B contains data about that person (essentially, a job title).

On another worksheet, I used validation to create a pull-down in a particular cell, where the options in the pull-down are the set of names from the list on the first worksheet.

What I would like to do is this:
When someone selects a name from the pull-down, the next cell to the right is automatically populated with the job title associated with that individual,

For example: The list on worksheet one contains a row that has "Smith, John" in column A and "level 1" in column B. Worksheet 2 contains a cell with a pull-down made from the names in my list (one worksheet 1). If I select "Smith, John" from the pull-down, I want the cell to the right of my pull-down to be automatically populated with "level 1."

Does anyone know how to accomplish this?
Thanks!

----------------------------

Never mind, found solution (will leave this up in case anyone else is searching for the same answer).
VLOOKUP function does what I needed.

[DonkeyOte]

Check out the VLOOKUP function in XL Help.

The final (optional) range_lookup parameter will most likely need to be stipulated as 0 (or False) in this scenario... unless both of the below points hold true:

a) the names are sorted alphabetically on Sheet1

b) only names that exist on Sheet1 can appear in the Validation List on Sheet2

if either of the above are not true then using the default range_lookup parameter of 1 (or TRUE) will lead to erroneous results.