Date IF / Lookup

[Pippy79]

hi,

i have a long list of dates which i want to spread horizontally. i want to look up in column A and populate the correct month with the exact date shown.

example below would be from the list in column A, in cell B3 it should read 25APR2023.

Thanks

	A	B	C	D	E	F	G
1​		April	May	June	July	Aug	Sept
2​	8-Oct-23​
3​	25-Apr-23​
4​	6-Aug-23​
5​	19-Aug-23​
6​	29-Jun-23​
7​	10-Jun-23​

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1		Apr	May	Jun	Jul	Aug	Sep
2	08-Oct-23
3	25-Apr-23	25/04/2023
4	06-Aug-23					06/08/2023
5	19-Aug-23					19/08/2023
6	29-Jun-23			29/06/2023
7	10-Jun-23			10/06/2023
Master

Cell Formulas
Range	Formula
B2:G7	B2	=IF(TEXT($A2,"mmm")=B$1,$A2,"")

You will need to make your headers consistant, either 3 character abbreviation, or full name.

 

[ExceLoki]

another solution:

Book1
	A	B	C	D	E	F	G	H
1		April	May	June	July	August	September	October
2	8-Oct-23							8-Oct-23
3	25-Apr-23	25-Apr-23
4	6-Aug-23					6-Aug-23
5	19-Aug-23					19-Aug-23
6	29-Jul-23				29-Jul-23
7	10-Jun-23			10-Jun-23
Sheet1

Cell Formulas
Range	Formula
B2:H7	B2	=IF(DATE(YEAR($A2),MONTH($A2),1)=B$1,$A2,"")

 

[Georgiboy]

My effort:

Book1
	A	B	C	D	E	F	G	H
1		April	May	June	July	Aug	Sept	October
2	08-Oct-23	25/04/2023		29/06/2023		06/08/2023		08/10/2023
3	25-Apr-23			10/06/2023		19/08/2023
4	06-Aug-23
5	19-Aug-23
6	29-Jun-23
7	10-Jun-23
Sheet1

Cell Formulas
Range	Formula
B2:C2,E2,G2:H2,F2:F3,D2:D3	B2	=IFERROR(FILTER($A$2:$A$7,TEXT($A$2:$A$7,"mmm")=LEFT(B1,3)),"")

EDIT: Edited it to work with dates, i was working with text due to the way i pasted your data

 

[Pippy79]

Thanks all, so many options. they all worked!!

 

[Fluff]

Glad we could help & thanks for the feedback.