Help! I have created an index function with reference. In the functions arguments box, the correct result is being displayes in the formula result section.
However, in the cell, a competely different value is being displayed.
I cannot understand why the answer is correct in the function arguments box but not in the cell that the function is returned to.
Can anybody shed any light??
Thank you
