Magic! Thanks Nick.

On Fri, 24 Feb 2006 07:38:22 -0000, "Nick Hodge"
wrote:

Kaye

I worked with dates in B2:B25 so change to suit and obviously also change
the lookup range in the MATCH function.You will need to format J1 as date

=INDEX(B2:B25,MATCH("Pay",D2:D25,0))