VLOOKUP in Excel Referencing a Table in Access

[Simonc64]

Hi All

Is it possible to VLOOKUP a value from an Excel workbook, in a table in Access, with the result returned into the Excel workbook? Sounds like it should be possible and I can connect excel into the table in Access but cant seem to do anything but import the table in full back into Excel

Thanks in advance

Simon

 

[Rijnsent]

Hi Simon,
this solution is kind of what you are looking for, using MS Query: https://stackoverflow.com/questions/20977348/excel-vlookup-incorporating-sql-table
Cheers,
Koen