vlookup from Access db
If the Access table is not large then I would use Data External Data
New Database Query to bring the table into Excel from Access.
(or equivalent; the naming has changed with different versions of Excel
- it always helps us to help you if you specify)
You can then do the VLOOKUP in Excel referencing the table.
Alternatively, if you have a large table but only need a small number
of lookups, you could make each lookup be a Query using the barcode as
a parameter.
Finally, if you have a very large table and quite a lot of lookups then
it might be better to use a macro to navigate a recordset based on the
Access table, and populate the Volume column.
If you need help with your chosen route, come back
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|