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.