How to Lookup and Return a Unique Value

I have a spreadsheet which pulls in data from several queries.

Query 1 into RAW worksheet- User ID, User Name, Sign On Name, Application, Version, Function
Query 2 into Additional Data worksheet - ID, Name, Dept, Start Date, End Date, Last Logon, Password Change Freq, Password Change Date, Attempts, Company Status, Company

I then combine in a worksheet called User Analysis:

Company Name, User ID, User Name, Dept, Application, Version, Function Last Log On.
A VLOOKUP is used to find the Dept name using the User ID field.

The problem I am experiencing is VLOOKUP will not work to return Company and Last Log On as it will only find the first match and will then go no further.  I have tried INDEX and MATCH with the same result.

I would greatly appreciate any help.

I have attached an example of what I am trying to do.