Index Match with criteria

[pedexe90]

Hi everyone,

I need help improving a formula. This is the current format of my formula : =IFERROR(INDEX($G$3:$G$137,MATCH(I3,$B$3:$B$137)*($G$3:$G$137>0),0),"")

What I need is to match a date between column I adn B and to return Values from G only if there is a value. Dates are repeated in column B. Column I has dates in order and sequence so for example 01/12/2017 + 1.


[TABLE="width: 729"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]¹Entry Date[/TD]
[TD]Transaction Details[/TD]
[TD]²Transaction Type[/TD]
[TD]Payment Amount[/TD]
[TD]Receipt Amount[/TD]
[TD]Ledger Balance[/TD]
[/TR]
[TR]
[TD]01/12/2017[/TD]
[TD]TRANSFER 00113689[/TD]
[TD]Transfer[/TD]
[TD]88,176.43[/TD]
[TD] [/TD]
[TD]1,968,422.17[/TD]
[/TR]
[TR]
[TD]04/12/2017[/TD]
[TD]TRANSFER 83462862[/TD]
[TD]Transfer[/TD]
[TD] [/TD]
[TD]750.00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]04/12/2017[/TD]
[TD]TRANSFER 00113689[/TD]
[TD]Transfer[/TD]
[TD] [/TD]
[TD]860.35[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]04/12/2017[/TD]
[TD]INTEREST PAID GROSS FOR PERIOD TO 1DEC[/TD]
[TD]Credit[/TD]
[TD] [/TD]
[TD]1,302.69[/TD]
[TD]1,971,335.21[/TD]
[/TR]
[TR]
[TD]05/12/2017[/TD]
[TD]TRANSFER 83462862[/TD]
[TD]Transfer[/TD]
[TD] [/TD]
[TD]250.00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]05/12/2017[/TD]
[TD]TRANSFER 00113689[/TD]
[TD]Transfer[/TD]
[TD]542,525.93[/TD]
[TD] [/TD]
[TD]1,429,059.28[/TD]
[/TR]
[TR]
[TD]06/12/2017[/TD]
[TD]TRANSFER 83462862[/TD]
[TD]Transfer[/TD]
[TD] [/TD]
[TD]1,497.50[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]06/12/2017[/TD]
[TD]TRANSFER 00113689[/TD]
[TD]Transfer[/TD]
[TD]3,511.38[/TD]
[TD] [/TD]
[TD]1,427,045.40[/TD]
[/TR]
[TR]
[TD]07/12/2017[/TD]
[TD]TRANSFER 83462862[/TD]
[TD]Transfer[/TD]
[TD] [/TD]
[TD]750.00[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Maybe this... Control+shift+enter:

=IFERROR(INDEX($G$3:$G$137,MATCH(I3,IF(ISNUMBER(G$3:$G$137),

$B$3:$B$137),0)),"")​

​

​

<strike></strike>