Help with formula
 

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

Help with formula
 

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" wrote in message
oups.com...
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

Help with formula
 

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