Thread: Preventing incrementation of section of a formulae
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Preventing incrementation of section of a formulae
=VLOOKUP(A30,Sheet1!$A$1:$C$3,3,FALSE)

The $ signs make the references absolute so they don't change.


Gord Dibben MS Excel MVP


On Thu, 16 Aug 2007 18:21:29 -0700, whatzzup
wrote:

=VLOOKUP(A30,Sheet1!A1:C3,3,FALSE)

The above is a formulae that i will be dragging through my worksheet,
problem is a dont want this section ....Sheet1!A1:C3,......)
incrementing, is this possible? If so what do i do?


Reply With QuoteReply With Quote