This is a common problem. The trick is to use dollar signs when specifying
the table:

=VLOOKUP(1.3,$A$1:$C$10,2)
rather than
=VLOOKUP(1.3,A1:C10,2)
--
Gary''s Student


"Kappy" wrote:

When I do a vlookup and drag the formula down all the rows the formula
increments for each row so I wind up only getting partial data to move from
one spreadsheet to another. This is in Excel 2003. Do not seem to have the
same problem in Excel 2000