Can I set a Lookup formula in Excel to read data in an access table
using a macro?

What I'm after is for the user to put in a reference number in a cell
and the clients details to appear in an adjacent cell. I know this is
pretty easy to do completely in Excel but all my data appears in
Access. I do not want to export the Access data into Excel every time
I want to perform this function.

Thanks