Retrieve the second non-zero value in a row

I have a row of values and I need to pull the second non-zero value on another sheet, which in the example below is $850.


$0 $0 $0 $285 $850 $278 $481

I use the Index/Match forumla below to grab the first non-zero value ($285)

{=+INDEX($A$1:$G$7,MATCH(TRUE,$A$1:$G$7>0,0))}

This formula works great to retrieve the first non-zero value.

How can I modify this formula to grab the second non-zero value ($850)? Then how do I modify it again to grab the third non-zero value ($278)?
THen how do I modify to grab the fourth non-zero value ($481)?

I don't want to use IF/Then statement as that might be too long. I think Index/Match would do the trick, but I am missing somthing.

Any help will be appreciated!!
Coolmint

The array formula I am providing varies depending on the layout of your sheet. This formula currently assumes that your lookup range is A1:Z1. It also assumes that the formula is entered in Column A of the spreadsheet and filled across to the right.

Please post any follow up questions:

Please Login or Register  to view this content.

Thank you BigBas. That would work!!

One follow-up question. The formula is entered in Column A of the spreadsheet and filled across to the right.

I would also need to to put the formula into column A and fill Down. So it would go into A5, then A6, then A7.

How do i modify the formula so it fills down?

Thanks,
Coolmint

Anyone have any further detail into this fix? I'd like to retrieve the "850" value, my data appears similarly to the above post:

A B C D E F G H
Index/Match 285, NEWFORMULAHERE, $0 $0 $0 $285 $850 $278 $481