How can I isolate a lookup vectors but not values from autofill? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
rjpeltz 5/15/2006 8:47 AM PST
  Question
  Using Excel 2003, I want to click-and-drag-fill a lookup formula through a
column, changing the lookup value with each row, which happens automatically,
but referring to a fixed lookup table (in another sheet). I either have to
copy without autofill, and then go in and manually enter all of the lookup
values, or copy with autofill, and then go in and manually enter all of the
lookup vectors. There must be a way to isolate a lookup table from autofill,
as this must be a common need. What's the best way to do it? Thanks.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Ardus Petus 5/15/2006 9:14 AM PST
  Answer
  Use absolute references for your table, eg: $A$1:$C$999

HTH
--
AP

"rjpeltz" <rjpeltz@discussions.microsoft.com> a écrit dans le message de
news: 5D76A953-D99D-4C60-A498-EA187FA14D14@microsoft.com...
> Using Excel 2003, I want to click-and-drag-fill a lookup formula through a
> column, changing the lookup value with each row, which happens
> automatically,
> but referring to a fixed lookup table (in another sheet). I either have to
> copy without autofill, and then go in and manually enter all of the lookup
> values, or copy with autofill, and then go in and manually enter all of
> the
> lookup vectors. There must be a way to isolate a lookup table from
> autofill,
> as this must be a common need. What's the best way to do it? Thanks.


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
rjpeltz 5/15/2006 11:40 AM PST
   
  THANK YOU! I was unfamiliar with absolute references.

"Ardus Petus" wrote:

> Use absolute references for your table, eg: $A$1:$C$999
>
> HTH
> --
> AP
>
> "rjpeltz" <rjpeltz@discussions.microsoft.com> a écrit dans le message de
> news: 5D76A953-D99D-4C60-A498-EA187FA14D14@microsoft.com...
> > Using Excel 2003, I want to click-and-drag-fill a lookup formula through a
> > column, changing the lookup value with each row, which happens
> > automatically,
> > but referring to a fixed lookup table (in another sheet). I either have to
> > copy without autofill, and then go in and manually enter all of the lookup
> > values, or copy with autofill, and then go in and manually enter all of
> > the
> > lookup vectors. There must be a way to isolate a lookup table from
> > autofill,
> > as this must be a common need. What's the best way to do it? Thanks.
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies