vlookup with if statement

aicylaaa

New Member
Joined
Mar 21, 2018
Messages
3
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
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
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.
 
Upvote 0

Forum statistics

Threads
1,226,729
Messages
6,192,696
Members
453,747
Latest member
tylerhyatt04

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top