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