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

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