If your pay date table is at A2:A6, and your end period codes at B2:B6, with
your input date at A9, try
=INDEX(B2:B6,1+MATCH(A9,A2:A6,1))
--
David Biddulph

"Pendelfin" wrote in message
...
I have a table with the following information

Pay Date End Period
07-09-2006 0809
05-10-2006 0909
02-11-2006 1009
30-11-2006 1109
21-12-2006 1209

What I want to be able to do is enter a date for example 15/11/2006, and
it
tell me what the end period would be. Therefore it would look for the
first
higher paydate, in this case 30/11/2006 so therefore return a value of
1109.

Many Thanks in advance for your assistance