View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rajula Rajula is offline
external usenet poster
 
Posts: 53
Default Compare 2 sets of data

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