Why do I always have to drag down a formula in rows of data. I am filling in
data now on row 1,464 and I still have to drag down the data in certain
columns. Why will it not auto-complete? For example, in one column I have
this formula:
=IF(I1463="","",VLOOKUP(I1463,SHIPTO,2,FALSE)). It remains blank even when
the cell in column I is typed in. I have to drag down the formula from the
preceding row. It's frustrating and slows down productivity!! Any
suggestions?

Connie Martin