Vlookup with formula inside table array

Hello,

I am trying to have vlookup search another sheet for a certain value. The problem is I want it to search the sheets in the table_array based on one of the other cells. I want it to look at what value I have in b9, so the formula is =VLOOKUP(DATE(P5,1,1),B9!$A$3:$F$2520,2,TRUE) but when I press enter, it opens my documents on my computer instead of referencing the cell b9. Is there a formula that I need to put into the table array portion to make it work, or is it something else?

Thanks in advance