Excel "Index" Function with reference

By PAM77 ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums