Help with formula

[GregR]

I have a table like this:

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Month
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $20,000

where row 1 is month name (different lines because of wrapping)
row 2 is an amount (different lines because of wrapping). I need the
cell after 20,000 which in this case is "S2" to return the month in
which the value is >0. In this example the month would "Dec". TIA

Greg

 

[Bob Phillips]

Greg,

I am not seeing how you get Dec for the cell after 20000, ads Dec seems to
be with 20000 to me.

But perhaps you want

=INDEX(1:1,MATCH(20000,2:2,0)+1)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[GregR]

Bob, you are right 20,000 is with Dec. What I am looking for is to
return Dec to the cell, because it is the highest value in range F2:Q2
or the only value >0 in the range. You put me on the right track.
Thanks

Greg