COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE

  • Thread starter Thread starter SHELL
  • Start date Start date
S

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!
 
SHELL -

ABSOLUTE REFERENCE (INSTEAD OF RELATIVE):

$A$20:$A$38

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

Cliff Edwards
 
Thank you very much, you have saved me wasting hours of my time with such an
easy solution =]
 
Thank you very much, you have saved me wasting hours of my time with such an
easy solution =]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Offset formula 4
Loose formula/value (when building graphs) 3
>> Dynamic Range 2
Macro maximum range lengths 2
SUMIF with OFFSET 5
How to copy variable data from 2 worksheets into a seperate 3rdworksheet 12
named range in sum formula (indirect, offset, worksheet name) 4
formula to look up ref in one sheet and offset in another 1

Back
Top