| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Preventing incrementation of section of a formulae
=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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preventing incrementation of section of a formulae | New Users to Excel | |||
| Prevent auto incrementation of formula | Excel Discussion (Misc queries) | |||
| Transpose a cut section | Excel Discussion (Misc queries) | |||
| Scroller Incrementation | Charts and Charting in Excel | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Linear Mode
