R
Rajula
Compare 2 sets of data and return a true or false in a third column.
Can i use Pivots or lookups or any functions
I need list 2 to look at list 1 and compare and let me know that ID 1 is
mapped to the same Name & return true/false.
What makes it complicated is that Some IDs have 2 names mapped to it & the
names can be different. But even if 1 of the name
is different, if it returns a false, it will be sufficient.
List 1 List 2
ID Name ID Name
1 RW 1 RPS
2 ROP 2 CPM
3 RW 2 ROP
4 EPR 3 RW
5 DCE 4 DCE
5 RW 5 EPR
5 RW
This is what the result should look like.
ID Name
1 RPS False
2 CPM False
2 ROP False
3 RW True
4 DCE False
5 EPR False
5 RW False
Can i use Pivots or lookups or any functions
I need list 2 to look at list 1 and compare and let me know that ID 1 is
mapped to the same Name & return true/false.
What makes it complicated is that Some IDs have 2 names mapped to it & the
names can be different. But even if 1 of the name
is different, if it returns a false, it will be sufficient.
List 1 List 2
ID Name ID Name
1 RW 1 RPS
2 ROP 2 CPM
3 RW 2 ROP
4 EPR 3 RW
5 DCE 4 DCE
5 RW 5 EPR
5 RW
This is what the result should look like.
ID Name
1 RPS False
2 CPM False
2 ROP False
3 RW True
4 DCE False
5 EPR False
5 RW False