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!