I have posted a file at:
https://filesanywhere.com

I can enter cell referances in the arguments for the index function and it
will return the value in the intersecting cell, but when I enter the values
for the arguments by pointing to cells on another sheet I receive errors,
even though the value in the cells I pointed to is identical to the values
entered manually. I think that the posted file explains the problem better. I
would appreciate any help. Thanks.