Spreadsheet: 728830d1618679969-how-to-get-vlookup-to-pick-the-second-row-when-the-first-row-is-blank-scheduling-doc-1-
Sheet: Daily Attendance

 |  |  |  |  |  | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | January | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | February | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | March | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | April | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | May | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | June | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | July | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | August | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | September | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | October | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | November | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December | December
 | Late with notice | late without notice | no call no show | call out | Left early | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st