IF THEN UNLESS Help!

[LSmitthy]

I'm trying to create a formula that will reference amounts sorted in columns by date. I want the cell to pull the number from the most recent month. So basically it is:


J8=I8, unless I8=0
If I8=0, then J8=H8, unless H8=0
If H8=0, then J8=G8, unless G8=0
If G8=0, the J8=F8, unless F8=0
If F8=0, then J8=E8.

Anyone know how I can do this?

 

[shg]

There is surely an easier way, but ...

=IFERROR(INDEX(F8:I8, LARGE(IF(F8:I8<>0, COLUMN(F8:I8) - COLUMN(E8)), 1)), E8)

The formula MUST be confirmed with Ctrl+Shift+Enter rather than just Enter.

EDIT: Ah, confirmed in the usual way:

=IFERROR(LOOKUP(2, 1/(F8:I8<>0), F8:I8), E8)

 

[LSmitthy]

This worked perfectly! Thanks!

There is surely an easier way, but ...

=IFERROR(INDEX(F8:I8, LARGE(IF(F8:I8<>0, COLUMN(F8:I8) - COLUMN(E8)), 1)), E8)

The formula MUST be confirmed with Ctrl+Shift+Enter rather than just Enter.

EDIT: Ah, confirmed in the usual way:

=IFERROR(LOOKUP(2, 1/(F8:I8<>0), F8:I8), E8)

 

[shg]

You're welcome.