How do vlookup table array 2 column in excel

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.

Given that the From-dates are in a sorted series and given for all periods you want to lookup, what do you think of:

=LOOKUP($A3,$J$3:$J$25,$L$3:$L$25)

put in C3 and copy down

Regards,
berlan

you just need to remove 0 from last

Formula:

Please Login or Register  to view this content.

ARRAY Formula in D3 then drag down.

Please Login or Register  to view this content.

To enter ARRAY formula
Paste the formula
Press F2
Press Ctrl+Shift+Enter keys together.

berlan ,zbor ,shukla.ankur281190 ,kvsrinivasamurthy - thanks you so much excel captains.

Can you mark as solved and "Rep" those who helped you.

JohnTopley Sir,

Again i need the need the help. how do apply the vlookup row to column.

i have insert the drop down list in A1.

please help me.file attached.

Data:


Week01 Week01 Week02 Week02 Week03 Week03 Week04 Week04
Apr-15 01/04/2015 02/04/2015 03/04/2015 09/04/2015 10/04/2015 16/04/2015 17/04/2015 23/04/2015
May-15 01/05/2015 07/05/2015 08/05/2015 14/05/2015 15/05/2015 21/05/2015 22/05/2015 28/05/2015
Jun-15 01/06/2015 04/06/2015 05/06/2015 11/06/2015 12/06/2015 18/06/2015 19/06/2015 25/06/2015
Jul-15 01/07/2015 09/07/2015 10/07/2015 16/07/2015 17/07/2015 23/07/2015 24/07/2015 31/07/2015
Aug-15 01/08/2015 06/08/2015 07/08/2015 13/08/2015 14/08/2015 20/08/2015 21/08/2015 31/08/2015
Sep-15
Oct-15
Nov-15
Dec-15
Jan-16
Feb-16
Mar-16

Required Format:

Aug-15

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

SIVA SIR,

YOU ALWAYS LEGEND FOR EXCEL.ROCKING PERFORMANCE.

ESPECIALLY I LIKE TRICKS "Here you can delete entire columns G, I, K, M and O Then also the result will be the same"

LOT OF THANKS SIR.