Quote Originally Posted by Benzadeus
xld: why does the formula doesn't work if I take the 'N' function?
Because OFFSET returns cell references, we need the values, so with use N to force them to values.