I'm trying to use a drop down list with an if statement so when I choose a company from a drop down list some information will automatically fill in.
The company names are in column AF, the year is in column E, the claims info is in AB; SL Prem in AC; CF in AD; and Exp in AE. I need the claims, SL Prem, CF and EXP to automatically change when I select a company from the drop down list.
How can I write a formula so that when I select "company 1" it automatically sums all the claims information for 2013, 2014, etc.
A screenshot of how I have it organized: