Excel Not Recognizing Reference Pattern

Good morning!    Looking to see what the best/easiest option is as I've been trying to use an offset and lookup formula to no avail.   In columns A & B, I have a set of tables with dates by week ...