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]

I want to find 2 cells in Excel that are the same as the cells in the previous 2 columns

 

[Sufiyan97]

Try

=AND(A2=C1,B2=D1)

 

[pmeghnathi]

I want to find 2 cells in Excel that are the same as the cells in the previous 2 columns

Try

=AND(A2=C1,B2=D1)

I want this type formula

 

[Peter_SSs]

please provide 5 or 6 varied examples and the expected results.

OK, finally after another week and about 6 posts we have those examples and expected results!! Thank you!

23 08 18.xlsm
	A	B	C	D	E
1	MILAN	50	GORI	30	TRUE
2	SHANTI	20	MIHIR	50	FALSE
3	PRASHANT	90	PRASHANT	90	TRUE
4	VIJAY	21	VIJAY	21	TRUE
5	GORI	30	SHANTI	20	TRUE
6	MIHIR	1000	MILAN	50	TRUE
Match

Cell Formulas
Range	Formula
E1:E6	E1	=ISNUMBER(MATCH(C1&D1,A$1:A$6&B$1:B$6,0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[pmeghnathi]

OK, finally after another week and about 6 posts we have those examples and expected results!! Thank you!

23 08 18.xlsm
	A	B	C	D	E
1	MILAN	50	GORI	30	TRUE
2	SHANTI	20	MIHIR	50	FALSE
3	PRASHANT	90	PRASHANT	90	TRUE
4	VIJAY	21	VIJAY	21	TRUE
5	GORI	30	SHANTI	20	TRUE
6	MIHIR	1000	MILAN	50	TRUE
Match

Cell Formulas
Range	Formula
E1:E6	E1	=ISNUMBER(MATCH(C1&D1,A$1:A$6&B$1:B$6,0))
Press CTRL+SHIFT+ENTER to enter array formulas.

This formula work only numberic

Good formula work in image.
Thanks for help

 

[pmeghnathi]

This formula good work

 

[Peter_SSs]

This formula work only numberic

What is numberic? Do you mean numeric?

The formula has nothing to do with numeric. It checks if the values in column C & D occur somewhere in column A & B, which is what you asked for:

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

No numbers at all here

23 08 18.xlsm
	A	B	C	D	E
1	MILAN	xxx	GORI	+++	TRUE
2	SHANTI	abc	MIHIR	xxx	FALSE
3	PRASHANT	z@#$e	PRASHANT	z@#$e	TRUE
4	VIJAY	jkl	VIJAY	jkl	TRUE
5	GORI	+++	SHANTI	abc	TRUE
6	MIHIR	B	MILAN	xxx	TRUE
Match

Cell Formulas
Range	Formula
E1:E6	E1	=ISNUMBER(MATCH(C1&D1,A$1:A$6&B$1:B$6,0))
Press CTRL+SHIFT+ENTER to enter array formulas.

You said

I want this type of formula

That is exactly what my formula does.

 

[pmeghnathi]

Not working

 

[pmeghnathi]

I use office 2003 & 2016

 

[Peter_SSs]

I use office 2003 & 2016

That is not what your profile shows.

Note how the formula must be entered as shown under all my mini sheets.