You can't point a VLOOKUP to Access. You'd have to write code or
use a query table to bring the data into Excel and uses that
range in VLOOKUP.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"dford" wrote in message
...
I would like to link data in Access to cells in Excel using
VLOOKUP. How
would this be done?