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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OFFSET
No, but if in A1 you were to put the text string A5, rather than the formula
=A5, then one cell could pick up the contents of A5, using the INDIRECT function =INDIRECT(A1), and another cell could pick up D5 using a combination of OFFSET and INDIRECT. -- David Biddulph "Jose Mourinho" wrote in message ... 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 |
Reply |
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 |