Formula help

[deuce]

Hi,


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

 

[Michael M]

Ok, then use the solution in post #2
The only way macros will cause problems, is if they are written incorrectly....OR put in the wrong location !

 

[deuce]

hi i was very exhausted and ended up falling asleep. The main point is to drag the formula across and down so the rows would change accordingly.

 

[Michael M]

Both the formula method AND the VBA solution will do that !!
As mentioned perviously did you try either of them on a small range of cells to make sure you get the desired result ?

 

[Michael M]

You do realise that the formula you provided has Absolute references ( $ signs)

=IF(AND(K3>=$D$41,K3<=$E$41), AZ$2,"")

which means that $D$41 and $E$41 will ALWAYS refer to that cell no matter which way you drag it !!