Thread: Preventing incrementation of section of a formulae
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Preventing incrementation of section of a formulae
Absolute reference

$A$1:$A$3

Mike

"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