Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Create a Value Based Upon The Contents of A List
When you say, up for review, do you mean they should be reviewed if their job
title is under the current month (example for now would be February) heading on sheet1? =IF(ISNUMBER(MATCH(C33,INDEX(Sheet1!$A$2:$L$3,0,MO NTH(TODAY()),1),0)),"R","") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "jeb" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Create a Value Based Upon The Contents of A List
Yes.
Tab 1(page 1) would have the employee's information. Tab 2 (page 2) would have the review schedule. There would be 12 columns. Each column would have titles & departments for review. "Luke M" wrote: When you say, up for review, do you mean they should be reviewed if their job title is under the current month (example for now would be February) heading on sheet1? =IF(ISNUMBER(MATCH(C33,INDEX(Sheet1!$A$2:$L$3,0,MO NTH(TODAY()),1),0)),"R","") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "jeb" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create list based on data table | Excel Discussion (Misc queries) | |||
sum cells based on contents of adjacent cell (validated list)? | Excel Worksheet Functions | |||
Create filename based on cell contents | Excel Worksheet Functions | |||
How to create a formula 5 to 10% based on given list of price | Excel Worksheet Functions | |||
Create List based on cell data | Excel Discussion (Misc queries) |