New user working on an excel scheduling system.

[Holmes89]

In excel I would like to enter a formula under the employee number column that when I enter an employee number it will auto populate the employee's name, position and skill code. All of these are on another sheet in the workbook Ie: employee number is column B, name is column C, position is column D and skill code is E.

First part looks like image 1, thats where I want to enter the information and have it auto populate.

Image 2 is where I want it to take the information from.

 

[Eric W]

Welcome to the MrExcel forum!

Sounds like you need VLOOKUP, something like:

=VLOOKUP(A2,'Other Sheet'!A1:D10,2,0)

where A2 is the employee number, Other Sheet!A1:D10 is the sheet with the info, 2 is the column you want returned, and 0 means you want an exact match.

 

[Holmes89]

Welcome to the MrExcel forum!

Sounds like you need VLOOKUP, something like:

=VLOOKUP(A2,'Other Sheet'!A1:D10,2,0)

where A2 is the employee number, Other Sheet!A1:D10 is the sheet with the info, 2 is the column you want returned, and 0 means you want an exact match.

Thank you ! this is exactly what I needed. appreciate that.