Try:

=IF(AS18=ROW(A18),A18,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Barty" wrote in message
...
How do i get the constants in a formula to change when i fill down
EG
=if(as18=18,a18,"") in cell X
=if(as19=19,a19,"") in cell Y