Retrieve data from Access

[pschepeler]

I need to assign a value to a cell from an Access table by comparing the values from three cells in the worksheet with their corresponding fields in the Access table.

Please help

 

[Asala42]

There might be a better solution - but a quick and dirty first step would be to pull the Access table/query into an excel sheet as a datasource then work from there. You can do this fairly easily by hitting Data/Get External Data/New Database Query. You might want to make an additional query in access just to supply excel with only the data you need.

Hope that helps, somewhat