View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JEB JEB is offline
external usenet poster
 
Posts: 40
Default How To Create a Value Based Upon The Contents of A List

Our company provides quarterly employee reviews.

What would be the best function to use in the following scenario:

We create (re-use) a monthly spreadsheet of employees, title, department,
main duties, & contact information.

We have a list of titles & departments (on a separate tab) divided by the
month that the title or department is due for review:
Column A:JANUARY
ADMINISTRATIVE ASSISTANTS
PAYROLL

Column B:
FEBRUARY
INTERNS
MARKETING

We want to add a column to the far left of the monthly spreadsheet so that
each employee has a cell to indicate if they are up for review.

Review? Name Title Department Duties Phone Email
R TEST PERSON ADMINISTRATIVE ASST. ADMINISTRATIVE DUTIES
x-1234

Would an IF or VLOOKUP function be best for this?