Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Function? Employee Number with Employee Name
I have a spreadsheet that I believe that I need some form of LOOKUP function,
but have been unable to find the type that I need. I have a column "C" that has an employee number in it. I have created a table on Sheet 2 with the Employee Number and the corresponding Employee Name in that table. I want to have the column "D" on Sheet 1 to automatically fill in the Employee Name based on the Employee Number in column "C". What type of function would this be? and suggestions on syntax? Thanks for the help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Function? Employee Number with Employee Name
=VLOOKUP(c1,Sheet2!A:B,2,FALSE)
Or for instances that thre are no employee on the list =if(isna(VLOOKUP(c1,Sheet2!A:B,2,FALSE))=true,"no employee on the list",VLOOKUP(c1,Sheet2!A:B,2,FALSE)) -- Please click "yes" if this post helped you! Greatly appreciated Eva "Lance Hebert" wrote: I have a spreadsheet that I believe that I need some form of LOOKUP function, but have been unable to find the type that I need. I have a column "C" that has an employee number in it. I have created a table on Sheet 2 with the Employee Number and the corresponding Employee Name in that table. I want to have the column "D" on Sheet 1 to automatically fill in the Employee Name based on the Employee Number in column "C". What type of function would this be? and suggestions on syntax? Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to lookup employee name and return data from multiple rows | Excel Worksheet Functions | |||
Calculate employee hours for employee evaluation? | Excel Worksheet Functions | |||
Fromula to take employee # out of employee name field | Excel Discussion (Misc queries) | |||
Employee number and name | New Users to Excel | |||
Employee Wage Lookup | New Users to Excel |