Hi Adasca
Have a look at the attachment, which shows an array formula that should work if you can inport your database into Excel. In my example, your database would be columns A to E, which is a list of employees. Details of all database records for a given name (cell J18) are placed in the extract table (your template?) - Cols J to M. It can handle multiple rows and columns from the database. You can either enter the lookup reference (name) or select from a drop down list as in the example. If you haven't used an array formula before, don't worry. They are identified by the curly brackets around the formula, which are put in place by Excel as a final step when you have entered or amended the formula. You instruct Excel to complete this step by pressing the key combination Control+Shift+Enter.
Once you have the array formula however you can copy and paste it to other cells normally including the curly brackets.
HTH Hercules
Bookmarks