Return employee name when the employee's number is entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my workbook I have a sheet that contains two columns. One has employee
name and the second has an employee number. Now, on another sheet I want to
enter an employee number and in the next cell have it return the employee's
name. How can I do this?
 
If the second is to the right you can use a simple VLOOKUP. See in HELP
index.
If on the left you would need to use MATCH to find the row and then
incorporate into an INDEX function. Again, the HELP index is your friend.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Function? Employee Number with Employee Name 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Employee Scheduling Worksheet 10
how to accumulat the amounts of employees monies from worksheets 1
Index Match to add employee number 2
View Message when Mouse Hovers over Cell. (Not the Comments Feild) 2
Adding up total hours worked on employee schedule using various criteria 0
Lookup function 2

Back
Top