COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE

[SHELL]

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!

 

[Mike Middleton]

SHELL -

ABSOLUTE REFERENCE (INSTEAD OF RELATIVE):

$A$20:$A$38

- MIKE

 

[ward376]

USE ABSOLUTE REFERENCES!

$A$20:$A$38

CLIFF EDWARDS!

 

[ward376]

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

Cliff Edwards

 

[SHELL]

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

 

[SHELL]

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