Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with dates and lookups
Please can someone help
I have a table, of dates and references. What I want to be able to do is input a date, and it then lookup to see what the refernce should be for this. IE Date Reference 10/01/2006 Period 1 16/02/2006 Period 2 19/03/2006 Period 3 25/04/2006 Period 4 So if I enter a date of 25/02/2006 it brings back PERIOD 2 as this date is greater than Period 2 but less than Period 3. Many Thanks in advance for your assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with dates and lookups
assuming you know how to to use lookup table, i would name your periods table
as "periods" and assuming the date you want to put into a period is located in A1, the formula is =vlookup(A1, periods,2,true). this will return the period the date falls in, several chances for errors, if date is before first period or after last period. reno "Pendelfin" wrote: Please can someone help I have a table, of dates and references. What I want to be able to do is input a date, and it then lookup to see what the refernce should be for this. IE Date Reference 10/01/2006 Period 1 16/02/2006 Period 2 19/03/2006 Period 3 25/04/2006 Period 4 So if I enter a date of 25/02/2006 it brings back PERIOD 2 as this date is greater than Period 2 but less than Period 3. Many Thanks in advance for your assistance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with dates and lookups
The date could be any date I just need to know what period the date previous
or equal to this equals. This date will not necessarily be in the first column. "reno" wrote: assuming you know how to to use lookup table, i would name your periods table as "periods" and assuming the date you want to put into a period is located in A1, the formula is =vlookup(A1, periods,2,true). this will return the period the date falls in, several chances for errors, if date is before first period or after last period. reno "Pendelfin" wrote: Please can someone help I have a table, of dates and references. What I want to be able to do is input a date, and it then lookup to see what the refernce should be for this. IE Date Reference 10/01/2006 Period 1 16/02/2006 Period 2 19/03/2006 Period 3 25/04/2006 Period 4 So if I enter a date of 25/02/2006 it brings back PERIOD 2 as this date is greater than Period 2 but less than Period 3. Many Thanks in advance for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM of INDEX lookups | Excel Worksheet Functions | |||
CAN DATES BE USED IN LOOKUPS? | Excel Discussion (Misc queries) | |||
Lookups | Excel Discussion (Misc queries) |