INDEX/MATCH formula not working

[Steph_pmg]

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.

 

[Aladin Akyurek]

=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.

 

[Steph_pmg]

Still says #n/a

 

[Aladin Akyurek]

Still says #n/a

That means:

A10 is not available in 'Bank Pivot'!$B$5:$B$499. Check if this is wrong.​

 

[Steph_pmg]

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

 

[Aladin Akyurek]

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>