Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date ranges
I have in Sheet A the following date ranges and corresponding data
B2 C2 D2 E2 01/01/2004 01/02/2004 01/03/2004 01/04/2004 .... UNTIL dEC 2018 and B3 c3 D3 E3 48% 50% 52% 62% SHEET B CONTAIN THE FOLLOWING DATA B2 C2 D2 E2 01/01/2008 01/02/2008 01/03/2008 Until Dec 2018 What I am looking for is to lookup the date in Sheet B from the date range in Sheet A and return the percentage value for the corresponding date in sheet B . Since the columns are not aligned together in both the sheets it is giving different values. Can anyone come up with a formula |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date ranges
One way:
Sheet B: B3: =HLOOKUP(B2,'Sheet A'!$B$2:$FY$3,2) Copy to the right as far as desired. In article om, "Fortune" wrote: I have in Sheet A the following date ranges and corresponding data B2 C2 D2 E2 01/01/2004 01/02/2004 01/03/2004 01/04/2004 .... UNTIL dEC 2018 and B3 c3 D3 E3 48% 50% 52% 62% SHEET B CONTAIN THE FOLLOWING DATA B2 C2 D2 E2 01/01/2008 01/02/2008 01/03/2008 Until Dec 2018 What I am looking for is to lookup the date in Sheet B from the date range in Sheet A and return the percentage value for the corresponding date in sheet B . Since the columns are not aligned together in both the sheets it is giving different values. Can anyone come up with a formula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
picking out date ranges | Excel Worksheet Functions | |||
compare date to various date ranges and sum value | Excel Worksheet Functions | |||
Date ranges in a sum formula | Excel Worksheet Functions | |||
If then Date Ranges | Excel Worksheet Functions | |||
sum of date ranges | Excel Worksheet Functions |