Linking data
 

I am trying to look up a reference value in a excel worksheet cell in an
access database to display, in excel, a value related to that reference.
i.e. enter a part number in a excel cell (reference). I want it to lookup
that part number in an access database query and to display the location of
the part in a cell on the excel worksheet