VLOOKUPs will stop at the first occurrence of the lookup value....

Excel_VBA

New Member
Joined
Dec 19, 2009
Messages
42
Suppose I am looking up value X. Value X appears 5 times on another spreadsheet with 5 different dollar amounts for each of the 5 X's that occur. The dollar amounts are: $1000, $2000, $2000, $2000 and $5000.

The VLOOKUP is stopping at the first X ($1000) and returning $1000. I would like for the VLOOKUP to consider all X's and return the total of all X's which is $12000.

Is there a way to do this?
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Try the SUMIF funciton.

=SUMIF(LookupColumn, LookupValue, SumColumn)


Hope that helps.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,156
Messages
5,600,049
Members
414,357
Latest member
Gemma_R

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
Top