If MONTH =Jan, Feb, etc use that months vale

[cgfitzp]

Hello All;

I have a sheet used to determine daily volumes based on Total Volume for each month. I divide this total by the number of work days, then multiply by 6 the number of work days each week to get average weekly volume.

I want to determine which month each week is in and use the weekly volume for that month.

I use 53 weeks for the year so have to repeat the process for 12 months and 52 weeks as the first week will always be January.

The test starting in G14 ;
IF C13=JAN use B6,
IF C13= FEB use C6
Using column D for the date would be OK, I put the column C month to hep me visualize the test.

I would repeat the MONTH test for each week G14 to G66


Thanks,
Chet

	A	B	C	D	E	F	G
1
2		Jan	Feb	Mar	Apr	May	Jun
3		4,660	4,011	5,010	4,412	4,627	4,600
4
5		27	25	26	26	26	26
6		1036	963	1156	1018	1068	1062
7
8		Monday Start Date	12/27/2021
9		Week Includes
10		01-01-YYYY
1
12				Date	Day	Year Wk	Wk Test
13			Dec	12/27/2021​	Monday​	2021_53	1036	<<Default B6
14			Jan	1/3/2022​	Monday​	2022_02	1036
15			Jan	1/10/2022​	Monday​	2022_03	1036
16			Jan	1/17/2022​	Monday​	2022_04	1036
17			Jan	1/24/2022​	Monday​	2022_05	1036
18			Jan	1/31/2022​	Monday​	2022_06	963
19			Feb	2/7/2022​	Monday​	2022_07	963
20			Feb	2/14/2022​	Monday​	2022_08	963
21			Feb	2/21/2022​	Monday​	2022_09	963

 

[GraH]

Going with your explanation (not your manual result)

Book1
	B	C	D	E	F	G	H	I
2	Jan	Feb	Mar	Apr	May	Jun
3	4,66	4,011	5,01	4,412	4,627	4,6
4
5	27	25	26	26	26	26
6	1036	963	1156	1018	1068	1062
7
8	Monday Start Date	12/27/2021
9	Week Includes
10	01-01-YYYY
11
12			Date	Day	Year Wk	Wk Test	Using C	Using D
13		Dec	27/12/2021	Monday	2021_53	1036	1036	1036
14		Jan	3/01/2022	Monday	2022_02	1036	1036	1036
15		Jan	10/01/2022	Monday	2022_03	1036	1036	1036
16		Jan	17/01/2022	Monday	2022_04	1036	1036	1036
17		Jan	24/01/2022	Monday	2022_05	1036	1036	1036
18		Jan	31/01/2022	Monday	2022_06	963	1036	1036
19		Feb	7/02/2022	Monday	2022_07	963	963	963
20		Feb	14/02/2022	Monday	2022_08	963	963	963
21		Feb	21/02/2022	Monday	2022_09	963	963	963
Sheet3

Cell Formulas
Range	Formula
H13:H21	H13	=IFERROR(INDEX($B$6:$G$6,MATCH(C13,$B$2:$G$2,0)),$B$6)
I13:I21	I13	=IFERROR(INDEX($B$6:$G$6,MATCH(TEXT(D13,"mmm"),$B$2:$G$2,0)),$B$6)

 

[cgfitzp]

Thank you for quick response, I've been out of the office, my wife had major surgery, i'll work with your suggestions today, Chet

 

[GraH]

my wife had major surgery

Hope all is well now. Wishing her a good recovery.

 

[cgfitzp]

GraH;​

The version using the dates works perfectly, thank You.

=IFERROR(INDEX($B$6:$G$6,MATCH(C13,$B$2:$G$2,0)),$B$6) always returned the value on "B6"

THanks Again,
Chet