ExcelBanter - Preventing incrementation of section of a formulae

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Preventing incrementation of section of a formulae (https://www.excelbanter.com/new-users-excel/154574-re-preventing-incrementation-section-formulae.html)

Mike H

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?

All times are GMT +1. The time now is 09:36 PM.