Copy and Pasting Formula but need to keep ONE CELL the same...

I have the following formula that I am having an issue with.

=IF(K4=11,CONCATENATE(N1,H4),"")

In this formula I need cell N1 to stay N1 while the other cells (K4 and H4) increase in increments (i.e. K4 to K5 , etc...) as I copy/drag the formula through my spreadsheet. I have to do this for 200+ rows so manually changing every cell isn't a very time consuming option.

Any help is appreciated.

Originally Posted by sweep

Hi,

Make it absolute be using dollar signs

=IF(K4=11,CONCATENATE($N$1,H4),"")

DANG IT! I knew it was simple... THANK YOU SO MUCH!