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.
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.
Saurabh Singh Teotia
Workbook Missing..Can you attach your workbook please...
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for such a quick response and a great answer.