Forum Discussion
Match names between two sheets and return value of a cell in the row
Hi
I am looking for a way to match a name between two sheets and then return a date value which is in a different cell in the same row.
So in sheet 2 if a site name in coulomb B matches a site name in sheet 1 coulomb A, return the value from a specific cell in the same row as where the names matched.
The data is sorted on dates which may change and I need to be able to show the updated date value in sheet 2 when date and order changes in sheet 1 for a specific site name.
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
11 Replies
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/
Thanks this worked perfectly.
