Home |
Search |
Today's Posts |
#1
|
|||
|
|||
DateValue & Vlookup?
Hello I am trying to create a 2 or 3 sheet workbook that will let me enter
tasks and dates much like a set up to a gantt chart. with the first sheet..... Job: Task start date end Date Days to completion Submission 08/08/05 08/13/05 47 days to go For the Days to completion column I am trying to use =DATEVALUE("11/09/2006")-TODAY()&" days to go" , Is there a way to Vlookup the "11/09/2006" portion of this formula. From whatever is entered in say column (C#). Then on a seperate sheet list Vlookup all the items that are under a certain number of days left as a priority list to check up the status of tasks. |
#2
|
|||
|
|||
yes, but you probably do not need the Date value if the cell if formatted as
a date "BEEZ" wrote: Hello I am trying to create a 2 or 3 sheet workbook that will let me enter tasks and dates much like a set up to a gantt chart. with the first sheet..... Job: Task start date end Date Days to completion Submission 08/08/05 08/13/05 47 days to go For the Days to completion column I am trying to use =DATEVALUE("11/09/2006")-TODAY()&" days to go" , Is there a way to Vlookup the "11/09/2006" portion of this formula. From whatever is entered in say column (C#). Then on a seperate sheet list Vlookup all the items that are under a certain number of days left as a priority list to check up the status of tasks. |
#3
|
|||
|
|||
And For the second Sheet if two or more items fall under the same time period
of Days to Completion can it populate a list in order of most urgent to farthest from completion. Referncing sheet one. Thanx for the tip on no "datevalue bj" "bj" wrote: yes, but you probably do not need the Date value if the cell if formatted as a date "BEEZ" wrote: Hello I am trying to create a 2 or 3 sheet workbook that will let me enter tasks and dates much like a set up to a gantt chart. with the first sheet..... Job: Task start date end Date Days to completion Submission 08/08/05 08/13/05 47 days to go For the Days to completion column I am trying to use =DATEVALUE("11/09/2006")-TODAY()&" days to go" , Is there a way to Vlookup the "11/09/2006" portion of this formula. From whatever is entered in say column (C#). Then on a seperate sheet list Vlookup all the items that are under a certain number of days left as a priority list to check up the status of tasks. |
#4
|
|||
|
|||
Check out advanced filter for the populating the second sheet.
there are many ways to populate the second sheet. a lot of them involve a countif or sumproduct to determine how much data meets the criteria Then a rank() is used to determine the order. If there is a "tiebreaker" method to keep from having identical ranks, a set of lookups based on the ranking can populate the second sheet "BEEZ" wrote: And For the second Sheet if two or more items fall under the same time period of Days to Completion can it populate a list in order of most urgent to farthest from completion. Referncing sheet one. Thanx for the tip on no "datevalue bj" "bj" wrote: yes, but you probably do not need the Date value if the cell if formatted as a date "BEEZ" wrote: Hello I am trying to create a 2 or 3 sheet workbook that will let me enter tasks and dates much like a set up to a gantt chart. with the first sheet..... Job: Task start date end Date Days to completion Submission 08/08/05 08/13/05 47 days to go For the Days to completion column I am trying to use =DATEVALUE("11/09/2006")-TODAY()&" days to go" , Is there a way to Vlookup the "11/09/2006" portion of this formula. From whatever is entered in say column (C#). Then on a seperate sheet list Vlookup all the items that are under a certain number of days left as a priority list to check up the status of tasks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |