Vlookup - using a database as the table_array

  • Thread starter Thread starter kbfalken
  • Start date Start date
K

kbfalken

I'm wondering if anyone knows if it's possible to use Vlookup and fo
the table_array to use an Access Database
 
No, it is not. VLOOKUP needs an Excel range to look at; it cannot directly
access an external database.
 
You could query the database from Excel and get the fields you want and then
work on that table in Excel
 
Back
Top