I need to search for the day and month from one sheet (Sheet1) and return the matching value from the sheet below (Sheet2). The values I'm searching for start in row 4 of Sheet1 with the day listed in column B and the month listed in column Q. As an example from Sheet1, the day in B4 is Monday and the month in Q4 is November so I want to return the value highlighted in red from Sheet2 which is 4. The letters in the first row below are the columns from Sheet2 and the headers start in row 18 if needed. I can't sort out the index/match. Any guidance would be appreciated.
| B | C | D | E | F | G | H | I | J | K | L | M |
| MONTH | DATA1 | DATA2 | DATA3 | DAYS | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |
| OCTOBER | 31 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | |||
| NOVEMBER | 30 | 4 | 4 | 4 | 5 | 5 | 4 | 4 | |||
| DECEMBER | 31 | 5 | 4 | 4 | 4 | 4 | 5 | 5 | |||
| JANUARY | 31 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | |||
| FEBRUARY | 29 | 4 | 4 | 4 | 4 | 5 | 4 | 4 | |||
| MARCH | 31 | 5 | 4 | 4 | 4 | 4 | 5 | 5 | |||
| APRIL | 30 | 4 | 5 | 5 | 4 | 4 | 4 | 4 | |||
| MAY | 31 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | |||
| JUNE | 30 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | |||
| JULY | 31 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | |||
| AUGUST | 31 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | |||
| SEPTEMBER | 30 | 5 | 5 | 4 | 4 | 4 | 4 | 4 |
