automatically insert formula when new rows are inserted

I need to prepare a spreadsheet for users who will enter data. When they add
new rows I need for formuals to match any in the previous rows. How do I do t
his ?