how do I get a formual to stay constant in vlookup in Excel 2003

G

Guest

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
 
G

Guest

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)
 
K

KellTainer

Hi,

Perhaps you have to set whether the cell references in the formula to
be fixed in both row or column both whenever they are extended down
using F4 (eg. $A$3, $A3, A$3 or A3) so that when you specify a
constant, make sure both its row and column has a dollar sign so that
all the references extended will still pickup the same reference.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup Error Message - Excel 2003 8
VLookup Help 1
use VLookup to copy more than 1 cell 3
Vlookup and Hlookup 3
how can we make one constant number to be act as variable 3
constant in formulas 3
Array VLOOKUP lookup_Value does not increment 3
Vlookup or Other vs Sort? 1

Top