Fill cells base on some IF and MATCH formula

[kepasso]

Hi

I need to fill cells - actual balance, base on these conditions:
1. account nr.
2. date, if there is no date balance than have to fill previous cell (date balance)

I did this, but it doesn't fill missing date:

=IF(MATCH(1,($B$2:$B$30=E3)*($A$2:$A$30=$F$2),0),VLOOKUP(E3,$B:$C,2,FALSE),F2)

thanks

fill.xlsx

[FDibbins]

Try this regular formula, copied down, and the copied across...
=INDEX($C$2:$C$30,MATCH($E3&" "&F$2,INDEX($B$2:$B$30&" "&$A$2:$A$30,0),0))

Note that not all dates have a match with the account number. To hide the error answers, use this...
=IFERROR(INDEX($C$2:$C$30,MATCH($E3&" "&F$2,INDEX($B$2:$B$30&" "&$A$2:$A$30,0),0)),"")

[newdoverman]

This is based on the formula by Ford and is only good for a maximum of 2 consecutive errors.

In E3 enter:

Please Login or Register  to view this content.

In I3 enter:

Please Login or Register  to view this content.

Spaces are used to show the corrections made by IFERROR statements.

[kepasso]

Thank you very much