Can vlookup be used to get a result from an Access Database Table?
Thanks.
Can vlookup be used to get a result from an Access Database Table?
Thanks.
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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks