1

Excel Problem - please open this attachment file

I want to get the latest END BALANCE of customer, when the STATUS is success. Picture of the table and result wanted is attached above.

fixer1234
  • 28,064
harimin
  • 25

1 Answers1

1

Assuming that your data is sorted descending by column A, use in cell H4:

=IFERROR(INDEX($E$2:$E$17,MATCH(1,(($C$2:$C$17="success")*($B$2:$B$17=$G4)),0)),"error")

This is an array formula and must be confirmed with Ctrl - Shift - Enter.

Copy down.

teylyn
  • 23,615