Use Vlookup and PivotTable. doc.
How to Vlookup next largest value in Excel?
Vlookup: When and how to use it.
Lookup Functions such as Vlookup and Hlookup on exact & approximate match.
Have you ever used Vlookup to bring a column from one table into another table?
In Excel 2003 and earlier versions, this Vlookup was referencing a whole row that included
only 655,560 cells(10 columns x 65,536 rows).
When you need to find and extract a column of data from one table
and place it in another, use the Vlookup function.
Vlookup is one of the most popular, useful functions in
Excel, but it's hard to remember the formula if you don't use it that often.
Sometimes, you need to Vlookup from right to left,
the normal Vlookup function will not work, here is a simple formula can help you, please do as this:.
Vlookup Lookup a value in a table by matching on the first column
and return value from a certain column lookup value, Table array, Col index,[ Range lookup].
Vlookup function is useful in Excel,
but when you drag the autofill handle to fill range with a Vlookup formula, there may appear some errors. Now this tutorial will tell you the correct way to auto fill Vlookup function in Excel.