COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE
 

I AM USING THE OFFSET FUNCTION FOR LOOKING UP CERTAIN INFORMATION IN ANOTHER
WORKSHEET. THIS INFORMATION IS CONTAINED WITHIN A RANGE OF FIELDS EG: A20:A38
WHEN I COPY THIS FORMULA IT AUTOMATICALLY UPDATES THE FIELDS EG: A21:A39 AND
SO ON. HOW DO I TURN THIS OFF. I WANT IT TO STAY AT A20:A38.
I AM USING EXCEL 2002.
I HAVE TRIED EVERYTHING I CAN THINK OF AND GETTING VERY FRUSTRATED!

COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE
 

SHELL -

ABSOLUTE REFERENCE (INSTEAD OF RELATIVE):

$A$20:$A$38

- MIKE


"SHELL" wrote in message
...
I AM USING THE OFFSET FUNCTION FOR LOOKING UP CERTAIN INFORMATION IN
ANOTHER
WORKSHEET. THIS INFORMATION IS CONTAINED WITHIN A RANGE OF FIELDS EG:
A20:A38
WHEN I COPY THIS FORMULA IT AUTOMATICALLY UPDATES THE FIELDS EG: A21:A39
AND
SO ON. HOW DO I TURN THIS OFF. I WANT IT TO STAY AT A20:A38.
I AM USING EXCEL 2002.
I HAVE TRIED EVERYTHING I CAN THINK OF AND GETTING VERY FRUSTRATED!

COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE
 

USE ABSOLUTE REFERENCES!

$A$20:$A$38

CLIFF EDWARDS!

COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE
 

Please don't yell at us... typing in all caps are perceived as
yelling.

Cliff Edwards

COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERA
 

Thank you very much, you have saved me wasting hours of my time with such an
easy solution =]



"Mike Middleton" wrote:

SHELL -

ABSOLUTE REFERENCE (INSTEAD OF RELATIVE):

$A$20:$A$38

- MIKE


"SHELL" wrote in message
...
I AM USING THE OFFSET FUNCTION FOR LOOKING UP CERTAIN INFORMATION IN
ANOTHER
WORKSHEET. THIS INFORMATION IS CONTAINED WITHIN A RANGE OF FIELDS EG:
A20:A38
WHEN I COPY THIS FORMULA IT AUTOMATICALLY UPDATES THE FIELDS EG: A21:A39
AND
SO ON. HOW DO I TURN THIS OFF. I WANT IT TO STAY AT A20:A38.
I AM USING EXCEL 2002.
I HAVE TRIED EVERYTHING I CAN THINK OF AND GETTING VERY FRUSTRATED!

COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERA
 

Thank you very much, you have saved me wasting hours of my time with such an
easy solution =]


"ward376" wrote:

USE ABSOLUTE REFERENCES!

$A$20:$A$38

CLIFF EDWARDS!