4 Columns compare

[pmeghnathi]

How do this formula in excel
A1=as b1=cd C1=as D1=cd
Result true'

A1=as b1=cd C1=as D1=a
Result fauls

 

[pmeghnathi]

The best way to do any formula can depend on your Excel version which is why I said this before:

How do match with formula in excel
A1=P b1=D C1=as D1=cd
A2=as b2=cd
Result E1 CELL IN TRUE

C1 AND D1 cell same value match in column A & B

 

[Peter_SSs]

Why are you not prepared to update your profile to show what Excel version(s) you have so we know which functions you have available?

 

[pmeghnathi]

Why are you not prepared to update your profile to show what Excel version(s) you have so we know which functions you have available?

Excel 2007

 

[Peter_SSs]

Excel 2007

Thanks. Now could you put that in your account details so that is is always visible/available? Post #4 explains how to do that.

 

[pmeghnathi]

How do match with formula in excel
A1=P b1=D C1=as D1=cd
A2=as b2=cd
Result E1 CELL IN TRUE

C1 AND D1 cell same value match in column A & B

 

[pmeghnathi]

 

[Peter_SSs]

Thank you for updating your details.

One example is very little to go on. If this is not what you want, please provide 5 or 6 varied examples and the expected results.

23 08 11.xlsm
	A	B	C	D	E
1	P	D	as	cd	TRUE
2	as	cd
Sheet5

Cell Formulas
Range	Formula
E1	E1	=AND(C1=A2,D1=B2)

 

[pmeghnathi]

 

[Peter_SSs]

I cannot read/interpret that very well & I cannot copy it for testing.
Can you provide that sample data with XL2BB and add written explanation?

 

[pmeghnathi]

I want to find the value of c1 d1 in column A AND B
A1=P b1=D C1=as D1=cd
A2=as b2=cd
Result E1 CELL IN TRUE