regarding recognition of date & after recognition value placement in the designated cell

[determinedtoexceed]

Dear Pros,

Is is possible for cell to recognize of date(month) & after recognition, it places the desired value in the designated cell?

In this case, for APAC01, I want "2640" of "8/30/19" in Aug cell.

Thank you so much for the help.

 

[jorismoerings]

Hi,

something like this:

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Jan	feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	ETA1	Qty	ETA2	Qty
2								2.640,00					8/30/19	2640
Sheet1

Cell Formulas
Range	Formula
I2	=IF(AND(YEAR(DATEVALUE("1/"&I$1&"/2019"))=YEAR($N2),MONTH(DATEVALUE("1/"&I$1&"/2019"))=MONTH($N2)),$O2,0)

 

[determinedtoexceed]

Hi,

something like this:

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
Jan	feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	ETA1	Qty	ETA2	Qty

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 2.640,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]8/30/19[/TD]
[TD="align: right"]2640[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I2[/TH]
[TD="align: left"]=IF(AND(YEAR(DATEVALUE("1/"&I$1&"/2019"))=YEAR($N2),MONTH(DATEVALUE("1/"&I$1&"/2019"))=MONTH($N2)),$O2,0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you so much for the help, it works well.
Can the function remove recognition of year?, only recognize month

 

[determinedtoexceed]

I figured out on removal of year from the function

thank you so much for the prompt response.