Excel - Index Match With Multiple Criteria - HELP

shkhaslam

New Member
Joined
Nov 22, 2014
Messages
44
Hi Guys,

Need a lil help.

<a href="https://ibb.co/mhrsf3P"><img src="https://i.ibb.co/frVRjsT/Excel-Sample.jpg" alt="Excel-Sample" border="0"></a>
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
First, you will get many more potential helpers if you explain your problem clearly in words and, if needed, post a small (copyable) screen shot or two directly in your post. My signature block below has help regarding that. We cannot copy from an image like you provided and many helpers will choose not to bother to manually type out the sample data. :)

Try this, copied down.


Excel 2016
ABCD
1
231/03/201031/03/20123.58%RESI
31/04/201231/05/20154.09%RESI
41/06/201514/11/20154.50%RESI
515/11/201531/03/20164.63%RESI
61/04/201631/05/20165.35%RESI
71/06/201630/06/20175.50%RESI
81/07/201731/03/20198.00%RESI
91/04/201928/07/20191.00%RESI
101/04/201928/07/20195.00%RESI1
111/04/201928/07/201912.00%COMM
12
19
201/07/2019RESI15.00%
2125/06/2015RESI4.50%
221/05/2019RESI1.00%
231/05/2019COMM12.00%
241/09/2017RESI8.00%
Rate
Cell Formulas
RangeFormula
C20=SUMPRODUCT(--(A20>=A$2:A$11),--(A20<=B$2:B$11),--(B20=D$2:D$11),C$2:C$11)
 
Upvote 0

Forum statistics

Threads
1,213,528
Messages
6,114,154
Members
448,553
Latest member
slaytonpa

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