This preview shows page 1. Sign up to view the full content.
Unformatted text preview: To reference data click on it in pivot table after selecting cell o You can rearrange data and correct value would still be displayed =Vlookup(value, pivottable, column number, FALSE) o The false makes it so it returns exact matches not close ones o Make references absolute o...
View Full Document
This note was uploaded on 12/06/2011 for the course ACIS 2504 taught by Professor Mtgriffin during the Fall '08 term at Virginia Tech.
- Fall '08