vlookup with if statement

[aicylaaa]

Hey everyone,

I'm trying to use a vlookup with an if statement so when I choose a company from a drop down list information will automatically fill in.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Drop Down[/TD]
[TD]Claims[/TD]
[TD]SL Prem[/TD]
[TD]CF[/TD]
[TD]Exp.[/TD]
[/TR]
[TR]
[TD]2013[/TD]
[TD]=vlookup(drop down,...?)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

This is how it should look, I'm in the "Claims" cell now trying to do a vlookup from the drop down to auto fill the information.

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.

How can I write a formula so that when I select "company 1" it automatically sums all the claims information for 2013, 2014, etc.

Thanks so much if anyone can help me figure this out it lol

 

[AFPathfinder]

Are you sure a SUMIFS function wouldn't help in this situation? You would just set the conditions to equal the company name chosen and the year. This is assuming your summation table is separate from the original data table.

The VLOOKUP function only returns a single value, so it may not be very useful in summing yearly totals.