vlookup other workbook

[swell estimator]

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

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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