Assign Value to Range Target

[Thomas Scott]

I need to take a starting number and based on its value assign it to the correct column range. Sounds simple to me, but is beyond this beginner. Here is an example of some values in Column A that need to be assigned to the right target column as a simple "1" (meaning occurring in that range). The red signifies unknown formula to me! Thanks. P.S. I watched a video of Excel international competition that required amazing knowledge combined with very fast strategic thinking.

Excel Formula for Splitting Date.xlsx
	A	B	C	D	E	F
1	Total Sales		2005-09	2010-14	2015-19	2020-24
2	2005		1
3	2011			1
4	2018				1
5	2024					1
6	2021					1
Sheet1

 

[Sam_D_Ben]

Something like this,

Book1
	A	B	C	D	E	F
1	Total Sales		2005-09	2010-14	2015-19	2020-24
2	2005		1
3	2011			1
4	2018				1
5	2024					1
6	2021					1
Sheet2

Cell Formulas
Range	Formula
C2:F6	C2	=IF(AND($A2>=VALUE(LEFT(C$1,4)), $A2<=VALUE(RIGHT(C$1,2))+2000), 1, "")