This is a slightly different question to the one answered by Teylyn a little while ago.
In column A are daily dates in format yyyymmdd. In column L are monthly dates in format Jan-90. In columns N-R are numbers (1 or 0) relating to each monthly date. I want to create a column of numbers (in say, columns C-G) for each day that match the respective number in columns N-R for the given month. So for example, all of the daily numbers in column C for the month of January 1990 in column A would be the same as the number for Jan-90 in column N.
I have attached a spreadsheet as an example. Sample.xlsx