if you enter data in 1 workbook and use the vlookup to access a database in
another workbook, how do you use the Insert Past Name in the Table Array
section of the Vlookup dialogue?

You can only use Insert Paste Name in the same workbook as the database.

Thank you