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.

1Entry Date	Transaction Details	2Transaction Type	Payment Amount	Receipt Amount	Ledger Balance
01/12/2017	TRANSFER 00113689	Transfer	88,176.43		1,968,422.17
04/12/2017	TRANSFER 83462862	Transfer		750.00
04/12/2017	TRANSFER 00113689	Transfer		860.35
04/12/2017	INTEREST PAID GROSS FOR PERIOD TO 1DEC	Credit		1,302.69	1,971,335.21
05/12/2017	TRANSFER 83462862	Transfer		250.00
05/12/2017	TRANSFER 00113689	Transfer	542,525.93		1,429,059.28
06/12/2017	TRANSFER 83462862	Transfer		1,497.50
06/12/2017	TRANSFER 00113689	Transfer	3,511.38		1,427,045.40
07/12/2017	TRANSFER 83462862	Transfer		750.00

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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>