John

You could use something like this...

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"John V" wrote in message
...
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