Question Locked

Excel "Index" Function with reference

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

This discussion is closed to new replies.