Excel - Pivot Tables

Hi Julie

Thank you for your question. I have included a link below to a microsoft support article that discusses the Index function in relation to Pivot tables.

http://support.microsoft.com/kb/213922

Do let us know if you have any further questions.

Kind regards,
Andrew