Hi Jacob, i added "+1" to display next rate, and i changed ranges.
A1:L1= rates
A3:L3= billings nr
Your code now: =INDEX(A1:L1,MATCH(9^9,A3:L3)+1)

All i need is this code to display a message if in A1:L1 finds an empty cell.
Mesaage to be "No more rates"
Can this be done?
Thanks!

"Jacob Skaria" wrote:

Try the below
=INDEX(A1:L1,MATCH(9^9,A2:L2))

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi Dan, in A1:L1 i have:
rate 1 rate 2 rate 3 rate 4.........rate 12
in A2:L2 i have
01.01.2009 01.02.2009 01.03.2009 ....01.12.2009

12 rates, 12 month. This is one of the rates. If i have only 7 rates
remaining, but the same range, the code will find an empty cell at some
point. So, i need to display a message.
EX:
this month will display "rate 7" (the last rate)
next month the code will find empty cell after "rate 7" and i neet to
display a message.

Can this be done?
Thanks!

"Dan" wrote:


Can you provide a bit more info. Exactly what data is in the ranges A1:L1 &
A2:L2?

"puiuluipui" wrote:

Hi, i need this code to display a message if next or last (when it finds
first empty cell) cell in A1:L1 is empty.

=INDEX(A1:L1,MATCH(MONTH(TODAY()),MONTH(A2:L2)-1))
Can this be done?
Thanks!