I used the Lookup Wizard to create a formula which is
=INDEX('Penalty Table'!$A$7:$F$26, MATCH(1,'Penalty Table'!$A$7:$A$26,),
MATCH(2003,'Penalty Table'!$A$7:$F$7,)). This only works one time.

I am creating a form where the employee enters the contract year, the
practice code number and then hopefully the percentage from the penalty
table is
automatically filled in. There will be several lines where they will be
filling in this information for contract holders. How can I enter this
formula for multiple entries? I think it has something to do with using
Ctrl-Shift-Enter to commit the formula. I don't understand how to use this.

Susan