COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE

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

ward376

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

Cliff Edwards
 
S

SHELL

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

SHELL

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

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
SUM & OFFSET & PIVOT TABLE?? 0
Macro maximum range lengths 2
call range by cell value 1
runtime error 9 subscript out of range 1
VBA code copying formula not running correctly 3
formula to look up ref in one sheet and offset in another 1

Top