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.