Hi Bill, thank you for your response.

I have many sheets with many lookups to many access tables (all within a
single db though), so I guess the last option would be best... can you
possible elaborate a bit more on this?

Thank you again!
W

"Bill Manville" wrote:

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