The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Excel question - merging sheets
Figgy
Fighter of the night manChampion of the sunRegistered User regular
Fighter of the night manChampion of the sunRegistered User regular
So I have two lists, each with two columns.
List A contains over 800 names in one column and "Yes" in the next column.
List B contains just under 100 names in one column and "No" in the next column.
All of the names from List B are on List A. I want to combine these two lists so that the names in List A that are duplicated in List B simply get updated in column 2 as "No."
Is there a way to do this easily?
List A contains over 800 names in one column and "Yes" in the next column.
List B contains just under 100 names in one column and "No" in the next column.
All of the names from List B are on List A. I want to combine these two lists so that the names in List A that are duplicated in List B simply get updated in column 2 as "No."
Is there a way to do this easily?
Figgy on
0
Posts
Add a third column on List A and use a VLOOKUP to see if that name appears on List B.
Add a filter and update the 'hits'
=vlookup(Value searching for, range you want to look through, index on row, if need exact match)
So for example, say List A is columns A & B (A being names, B being value), and List B is Columns C & D(c being name, D being value), with header values on the first row.
B2 = VLOOKUP(A2, C:C, 3, FALSE)
You could probably then add in an if statement
B2 = IF(VLOOKUP(A2, C:C, 3, FALSE), "NO", "YES") so that IF Vlookup finds the value in C (list 2), make it NO, else it's not found and make it yes. Then all you need to do is account for when #N/A comes in by using ISNA() function in excel.
to be something like:
B2 = IF(ISNA(VLOOKUP(A2, C:C, 3, FALSE)), "NO", "YES")