Forum Discussion
Match names between two sheets and return value of a cell in the row
A simple solution using VLOOKUP function is all you need.
Please see the attachment file.
But you have to learn how to use the VLOOKUP correctly and safely!
Here some sources about it:
https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
https://exceljet.net/excel-functions/excel-vlookup-function
A simple solution using VLOOKUP function is all you need.
Please see the attachment file.
But you have to learn how to use the VLOOKUP correctly and safely!
Here some sources about it:
https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
https://exceljet.net/excel-functions/excel-vlookup-function
I'm not sure if this thread is still viewed or not .. but here goes
So I have 2 sheets that both will use the username as the key in column A
Sheet 1 has all user names
Sheet 2 contains groups that users in sheet 1 could be associated with .. (each user could be associated with several groups)
I need to find each user and all of the groups they might be in (and this cannot be via a Pivot table ..mainly because this information is in 2 different sheets and there is thousands of rows of data)
Any help would be great!
Without seeing the data, I would think a Pivot Table would be the best approach here. Select the user names and all groups from sheet 2 > Insert > Pivot Table.
Pivot Table
- Add the Username column to Rows
- Add Group column to both Columns and Values
