| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OFFSET
I have A1 cell returning the value in A2, using '=A2'
In B1, is it possible to return the value in a fixed location relative to '=A2' (say, +3 columnds to D2) using OFFSET, or other function? e.g. If I changed A1 from '=A2' to '=A5', I want B1 to now return value in D5. Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset??? | Excel Discussion (Misc queries) | |||
| Offset Q | Excel Worksheet Functions | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| OFFSET | Excel Worksheet Functions | |||
| SUM() and OFFSET() CAUSES #VALUE | Excel Worksheet Functions | |||
Threaded Mode
