INDEX/MATCH formula not working

Steph_pmg

New Member
Joined
Jun 29, 2018
Messages
10
I tried the formula various ways. I want to match my date on my summary tab to the dates on my bank pivot tab which is a different worksheet and pull in the $$ amount for inflows.

I made sure that the values I am matching are both in "date" formatting, I also made sure there was no extra spaces in the cells.

First attempt:
=INDEX('Bank Pivot'!$B$5:$F$499,MATCH(A10,'Bank Pivot'!$B$5:$B$499,0),3)

Result: #N/A

Second attempt:
=INDEX('Bank Pivot'!$B$5:$B$499,MATCH(A10,'Bank Pivot'!$B$5:$F$499,0),3)

Result: #N/A

In both cases, the MATCH formula has an error per the "evaluate formula" feature.

Help is appreciated. Reference table is a pivot table, not sure if that is a problem but it usually is not.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
=INDEX('Bank Pivot'!$B$5:$F$499,MATCH(A10,'Bank Pivot'!$B$5:$B$499,0),3)

or just

=INDEX('Bank Pivot'!$D$5:$D$499,MATCH(A10,'Bank Pivot'!$B$5:$B$499,0))


should be ok.
 
Upvote 0
It worked, thanks. Now there is 2 values and it is only showing the first matched value. After all that, I am probably gonna use SUMIFS instead... UGH.
Thanks again
 
Upvote 0
It worked, thanks. Now there is 2 values and it is only showing the first matched value. After all that, I am probably gonna use SUMIFS instead... UGH.
Thanks again

Control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX('Bank Pivot'!$D$5:$D$499,SMALL(IF('Bank Pivot'!$B$5:$B$499=$A10,ROW('Bank Pivot'!$D$5:$D$499)-ROW(INDEX('Bank Pivot'!$D$5:$D$499,1,1))+1),ROWS($1:1))),"")
<strike></strike><strike></strike>
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

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