| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent auto incrementation of formula | Excel Discussion (Misc queries) | |||
| How do I print just the section a through f only? | New Users to Excel | |||
| 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
