Check out these videos about Pivot table and Vlookup
http://dev.itseasy.co.uk/excel-example-files/
"*" indicates required fields