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
Are there any other alternatives to using Vlookup?
Clerk_495can use a combination of INDEX & MATCH. There's more variability with using this process, but it's trickier to wrap your head around. When I was doing a lot with Excel, VLOOKUP was always sufficient for my purposes.
https://howtouseexcel.net/alternative-to-vlookup-index-match
Another helpful way to use VLOOKUP, if you don't have common cell data between 2 sheets to use as the LOOKUP_VALUE, is to use a combination of CONCATENATE and VLOOKUP. With this method, you are creating unique values through concatenation first before vlookup.
https://www.exceltactics.com/faster-multiple-criteria-lookups-vlookup-concatenate/
lukedeloosh Vlookup requires a table but whenever I create a table the excel spreadsheet removes it as well as all the formulas, does lookup Value do the same?
I will take a look at the INDEX & MATCH
Thanks this worked perfectly.
