In my Calc sheet the formula:
CELL(“address”) correctly returns $C$10
OFFSET($C$11,0,1,1,1) correctly returns the value in D11
but
OFFSET(CELL(“address”),0,1,1,1) returns Err:504 and I cannot understand why?
The error does not seem to be due to the lack of a 2nd reference variable in CELL either e.g. CELL(“address”; b2). Indeed ADDRESS() doesn’t work as a nested function of OFFSET for me either.
I know I can use the current cell’s relative address but I specifically want to use the ‘current’ cell format CELL(“address”) because I want to import a csv file where Column P has exactly the same formula in every row but when evaluated on import, returns the correct values for that row. Just what OFFSET does so well but this time I need it to relate to the current cell but without stating its explicit address.