I'm looking for help with the Below formula.

(IF(AND(K3>=D$41,K3<=E$41), AZ$2,"") Formula has to be dragged all the way to the right hand side as far as right goes, and down about 50000 cells. For the time being I had to do each cell manually, including visual error checking and it's like

Thanks in advance and I appreciate the help