IN THIS CHAPTER
Using the Worksheet Functions: An OverviewLocating Data with OFFSETFinding Data with INDEXFinding Data with MATCHUsing MATCH with Other FunctionsUsing VLOOKUPRearranging Data with TRANSPOSEGetting Data from a Pivot Table: GETPIVOTDATALooking Ahead
Using the Worksheet Functions: An Overview
Locating Data with OFFSET
Finding Data with INDEX
Finding Data with MATCH
Using MATCH with Other Functions
Using VLOOKUP
Rearranging Data with TRANSPOSE
Getting Data from a Pivot Table: GETPIVOTDATA
Looking Ahead