vlookup and Access Database Table
Can vlookup be used to get a result from an Access Database Table?
Thanks. |
vlookup and Access Database Table
The vlookup function itself is an Excel function and as such can only
retrieve data from an excel sheet. However you may be able to use the import external data menu option in the Data menu to retrieve your data from the access database, pull it into your excel workbook and then use the vlookup function. I never tried this myself, but maybe the idea can be applied. -- Jeroen van Nieuwkerk "finster26" wrote: Can vlookup be used to get a result from an Access Database Table? Thanks. |
All times are GMT +1. The time now is 06:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com