mileage sheet shortcut

[ClassyIrish]

I have a mileage sheet that needs to be coded per person at work. So C12 is
where the person types their name. A seperate spreadsheet has all company
employees listed along with the code that needs to be added. What I would
like to make happen is that the name typed in would be able to go to the
other spreadsheet, match the name and insert the correct business code. In
other words, like a telephone directory, I want to lookup someone name to get
their telephone number, but I can't figure out how, or where to start other
then the cell where I want to the code to go.

[SteveG]

ClassyIrish,

=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

or

=INDEX(Sheet2!A:B,MATCH(A:A,Sheet2!A:A,0),2)

Where A1 is the employee name and Sheet2! contains the list of names and business codes in columns A & B.

HTH

Steve