How do vlookup table array 2 column in excel

[silambarasan.J]

Sir,

lookup value are in row wise A3:A33. but table array column wise J22:K25,range lookup value in column L22:L25.

am trouble to vlookup from to/between 2 ranges.

the following formula am apply in B3={VLOOKUP(A3,CHOOSE({1,2,3},$J$3:$J$25,$K$3:$K$25,$L$3:$L$25),3,0)} but value return error most of rows.

Data:

I3:L3 (Table Array) (Range Lookup)

Month From to Date Week
Apr-15 01/04/2015 02/04/2015 Week01
Apr-15 03/04/2015 09/04/2015 Week02
Apr-15 10/04/2015 16/04/2015 Week03
Apr-15 17/04/2015 23/04/2015 Week04
Apr-15 24/04/2015 30/04/2015 Week05
May-15 01/05/2015 07/05/2015 Week01
May-15 08/05/2015 14/05/2015 Week02
May-15 15/05/2015 21/05/2015 Week03
May-15 22/05/2015 28/05/2015 Week04
May-15 29/05/2015 31/05/2015 Week05
Jun-15 01/06/2015 04/06/2015 Week01
Jun-15 05/06/2015 11/06/2015 Week02
Jun-15 12/06/2015 18/06/2015 Week03
Jun-15 19/06/2015 25/06/2015 Week04
Jun-15 26/06/2015 30/06/2015 Week05
Jul-15 01/07/2015 09/07/2015 Week01
Jul-15 10/07/2015 16/07/2015 Week02
Jul-15 17/07/2015 23/07/2015 Week03
Jul-15 24/07/2015 31/07/2015 Week04
Aug-15 01/08/2015 06/08/2015 Week01
Aug-15 07/08/2015 13/08/2015 Week02
Aug-15 14/08/2015 20/08/2015 Week03
Aug-15 21/08/2015 31/08/2015 Week04

Required Format:

Aug-15

A C(Lookup Value)

Date Required Format
01/08/2015 Week01
02/08/2015 Week01
03/08/2015 Week01
04/08/2015 Week01
05/08/2015 Week01
06/08/2015 Week01


file attached.please hep me.