ASAP~~Need to NOT auto-increment lookup formula

  • Thread starter Thread starter Jake S
  • Start date Start date
J

Jake S

I am running Excel 97 SR-1.
I have several worksheets with sheet one as my master list
(database if you will). I want to use sheet two in three
columns to lookup info from sheet one. What I have in
sheet two are three columns (ID Val to search for, Last
name, First Name). My formula in the Last and First names
uses the ID Val to search the master sheet for the name.
PROBLEM: I seem to be unable to fill or copy the formula
down the column in sheet two without Excel auto-
incrementing the reference range. Is there a way around
this.
 
Jake,

You can prevent Excel from incrementing the row reference and/or column
reference by using absolute references. E.g.,
=$A$1
instead of
=A1
 
Use a defined name for your table (select table and type the name in the
namebox above the row/column headers or go to insert>name>define) or use
absolute references like

$A$2:$B$100
 
Back
Top