If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|