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

Type the beginning of the formula, choose Window from the menu bar and click the other workbook, click EditGoto and click the
defined name

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"swell estimator" wrote in message
...
| 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