Hi Rodrick,

Thanks for the response. It certainly is going in the right direction.
In the result as, for ID 2, its returns TRUE, But for ID 5, It returns false.
My problem would me solved, its ID 2 also returned a FALSE. Is there a way.

Bcos my actual data is quiet large.

regards
Rajula

"Rodrick" wrote:

I have considered list 1 to be in Column A:B and List2 in Column D:E
Column A Column B Column D Column E
List1.ID List1.Name List2.ID List2.Name

Formuls used in cell F2:
=IF(ISERROR(VLOOKUP(D2,A:B,2,0)),"False",IF(VLOOKU P(D2,A:B,2,0)=E2,"True","False"))

My Result:

ID Name
1 RPS False
2 CPM False
2 ROP True (Different from one which you mentioned)
3 RW True
4 DCE False
5 EPR False
5 RW False

--
Cheers

Rodrick


"Rajula" wrote:

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