Connie

If you have XL2003 you could set this up as a list (DataList...) this will
autofill formulas
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Connie Martin" wrote in message
...
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