2019 | Jan |
Feb | |
Mar | |
Apr | |
May | |
Jun | |
Jul | |
Aug | |
Sep | |
Oct | |
Nov | |
Dec |
<colgroup><col><col></colgroup><tbody>
</tbody>
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