vlookup other workbook

  • Thread starter Thread starter swell estimator
  • Start date Start date
S

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
 
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
 
Back
Top