Use Vlookup formula to lookup data for items selected from a dropdown list.
Like if you select a the sales rep name from the dropdown list then his data is looked up automatically via Vlookup and a dash board is craeted showing his performance trends.
To craerte the dashbaord , i have used the follwoing formulas an dthier video links are vailable next to them
Max Formula – to find the highest value | http://www.youtube.com/watch?v=t6q8X76DcTM
Min Formula – to find the lowest value | http://www.youtube.com/watch?v=PKlWxszRn1U
Average Formula – to find the average |http://youtube.com/watch?v=H1zybkFnUCc
Vlookup Formula – do i need to tell 😉 | http://www.youtube.com/watch?v=8kZuIy9CVRs
Pie chart – to create a visual grapgh |http://www.youtube.com/watch?v=AHCr_rcr778
DropDown List – does it need a explanation ;-)|http://youtube.com/watch?v=3XC8J__t9zU