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 |
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 |
All times are GMT +1. The time now is 10:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com