ASAP~~Need to NOT auto-increment lookup formula

Giganews Newsgroups
Subject: ASAP~~Need to NOT auto-increment lookup formula
Posted by:  Jake S (ja…@uplinkusa.net)
Date: Mon, 6 Oct 2003

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.

Replies