VLOOKUP from Access Tables

  • Thread starter Thread starter Mraggie
  • Start date Start date
M

Mraggie

I need to do a VLOOKUP from a table in MSAccess. I want to use the same
Access table to provide data to multiple spreadsheets.

For instance, I have a client list that has client name and salesperson
name linked to the client number. I need to pull both the client name
and sales person by the client number in my Excel spreadsheets. The
only place I have this data is in Access. Because the data in the
Access table is live data, I don't want to repeatedly export that data
into a spreadsheet to complete my VLOOKUP.

Can anyone help???
 
In that scenario I would recomend a database query with parameters. You may
find the help on how to create them in MS Query help, and how to input the
parameter in Excel in the Excel file, but basically is editing the SQL code
that the wizard generates in MS Query to add a condition comparing to a ?
sign.

Hope this helps,
Miguel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How pull ID#s that meet specific "yes" requirements 3
Vlookup Error Message - Excel 2003 8
Multiple VLOOKUPS 4
vlookup for client list 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VLOOKUP Help 1
Vlookup from Access 1
Excel Vlookup Help 0

Back
Top