IF formula

[banneduser123]

so i have 4 columns...

Column A is a unique identifier,
Column B is a name for this unique identifer

Column C is another column of unique identifiers
Column D is another column naming this unique identifier


how can i create a formula that will goto column A, look at its name in the same row in column B, and then goto column C to see if column the unique identifier is present somewhere in column C, and if so tell me whether it was given the same name in column D. ...Meaning how it is being named in column D is the same way it was named in column B...

is this clear, or is more info needed?

 

[Blade Hunter]

Excel 2010
	A	B	C	D	E
1	ID	Value	ID	Value	Lookup
2	1	Hello	5	apple
3	2	World	6	orange
4	3	Some	1	Hello	Exact Match
5	4	Text	3	Something	Not a Match
Sheet2

Cell Formulas
Range	Formula
E2	=IFERROR(IF(AND(COUNTIF(A:A,C2)>0,VLOOKUP(C2,A:B,2,0)=D2),"Exact Match","Not a Match"),"")