| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a vlookup formula without changing the data range? | Excel Worksheet Functions | |||
| Copying a named range with a changing cell reference | New Users to Excel | |||
| named range in sum formula (indirect, offset, worksheet name) | Excel Worksheet Functions | |||
| Formula to find last value in a range & then offset | Excel Worksheet Functions | |||
| Copying a formula and changing ONE value... | Excel Worksheet Functions | |||
Threaded Mode
