It would be much easier to help you if you showed the formula you were using.
But are you adding $ signs around the table_array? Do you have the findings
set to FALSE?

"Sparkie" wrote:

I have a VLOOKUP formula and I am trying to use AutoFill to copy it down the
spreadsheet. If I look in each cell it looks like it copied the formula
correctly as it changes the cell numbers for the new rows but it does not
bring in the correct information, it enters a copy of what is in the original
cell. Any suggestions?
Sparkie