[TABLE="width: 151"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2019[/TD]
[TD="align: right"]Jan[/TD]
[/TR]
[TR]
[TD="align: right"]Feb[/TD]
[/TR]
[TR]
[TD="align: right"]Mar[/TD]
[/TR]
[TR]
[TD="align: right"]Apr[/TD]
[/TR]
[TR]
[TD="align: right"]May[/TD]
[/TR]
[TR]
[TD="align: right"]Jun[/TD]
[/TR]
[TR]
[TD="align: right"]Jul[/TD]
[/TR]
[TR]
[TD="align: right"]Aug[/TD]
[/TR]
[TR]
[TD="align: right"]Sep[/TD]
[/TR]
[TR]
[TD="align: right"]Oct[/TD]
[/TR]
[TR]
[TD="align: right"]Nov[/TD]
[/TR]
[TR]
[TD="align: right"]Dec[/TD]
[/TR]
</tbody>[/TABLE]
I have this it is formatted so they are dates not text or numbers
2019 is in A2-A13 then each date in in B2-B13
Across the top, i have headers so A1= year B1= month etc
here is what i am wanting to do
=index(C2:O150,match(XXXXXXXXXXX),match(Y1,C1:O1,0)
the xxxxxxx is where i get lost. I want this to be a match of a month and year so i need multiple pulls. I have all the months and years in a drop down so we can use W1 for the year and X1 for the month. If somone can please fill in the XXXXX part, that would be great. I dont know how to do a double match.
thanks
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2019[/TD]
[TD="align: right"]Jan[/TD]
[/TR]
[TR]
[TD="align: right"]Feb[/TD]
[/TR]
[TR]
[TD="align: right"]Mar[/TD]
[/TR]
[TR]
[TD="align: right"]Apr[/TD]
[/TR]
[TR]
[TD="align: right"]May[/TD]
[/TR]
[TR]
[TD="align: right"]Jun[/TD]
[/TR]
[TR]
[TD="align: right"]Jul[/TD]
[/TR]
[TR]
[TD="align: right"]Aug[/TD]
[/TR]
[TR]
[TD="align: right"]Sep[/TD]
[/TR]
[TR]
[TD="align: right"]Oct[/TD]
[/TR]
[TR]
[TD="align: right"]Nov[/TD]
[/TR]
[TR]
[TD="align: right"]Dec[/TD]
[/TR]
</tbody>[/TABLE]
I have this it is formatted so they are dates not text or numbers
2019 is in A2-A13 then each date in in B2-B13
Across the top, i have headers so A1= year B1= month etc
here is what i am wanting to do
=index(C2:O150,match(XXXXXXXXXXX),match(Y1,C1:O1,0)
the xxxxxxx is where i get lost. I want this to be a match of a month and year so i need multiple pulls. I have all the months and years in a drop down so we can use W1 for the year and X1 for the month. If somone can please fill in the XXXXX part, that would be great. I dont know how to do a double match.
thanks