I have an excel worksheet containing a list of userid's in
cell A, for each row I want to reference the userid in
cell A and connect to an external Oracle database to
lookup and return further details for that user.

eg.. their department and location etc..

Can you advise how I do this.

I am currently using Excel 2003