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