Found an error in Excel 2016 help documentation
The results column in the help window for the index function just mirrors the formula. Looks like it's because there's an apostrophe before the formula. Not sure where to report this. Looks like it's the same for 2013 too.
Thanks for the heads up. We’ve updated the topic, so the changes should go through shortly.
(And thanks Smitty for making the update!)
Thanks for the heads up. We've updated the topic, so the changes should go through shortly.