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]

Match A1 B1 WITH C1 D1

 

[kevin9999]

Do you mean like this?

Book1
	A	B	C	D
1	as	cd	as	cd
2
3	TRUE
Sheet1

Cell Formulas
Range	Formula
A3	A3	=A1&B1=C1&D1

Book1
	A	B	C	D
1	as	cd	as	a
2
3	FALSE
Sheet1

Cell Formulas
Range	Formula
A3	A3	=A1&B1=C1&D1

 

[Peter_SSs]

@kevin9999
That is a risky formula structure - see row 2 below.

@pmeghnathi
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I would suggest the formulas in the second section below.

23 08 06.xlsm
	A	B	C	D	E
1	as	cd	as	cd	TRUE
2	a	scd	asc	d	TRUE
3
4	as	cd	as	cd	TRUE
5	a	scd	asc	d	FALSE
Compare

Cell Formulas
Range	Formula
E1:E2	E1	=A1&B1=C1&D1
E4:E5	E4	=AND(A4=C4,B4=D4)

 

[pmeghnathi]

Do you mean like this?

Book1
	A	B	C	D
1	as	cd	as	cd
2
3	TRUE
Sheet1

Cell Formulas
Range	Formula
A3	A3	=A1&B1=C1&D1

Book1
	A	B	C	D
1	as	cd	as	a
2
3	FALSE
Sheet1

Cell Formulas
Range	Formula
A3	A3	=A1&B1=C1&D1

Thanks

 

[kevin9999]

Thanks

You're welcome, but please note Peter's response in post #4 as the best option

 

[pmeghnathi]

@kevin9999
That is a risky formula structure - see row 2 below.

@pmeghnathi
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I would suggest the formulas in the second section below.

23 08 06.xlsm
	A	B	C	D	E
1	as	cd	as	cd	TRUE
2	a	scd	asc	d	TRUE
3
4	as	cd	as	cd	TRUE
5	a	scd	asc	d	FALSE
Compare

Cell Formulas
Range	Formula
E1:E2	E1	=A1&B1=C1&D1
E4:E5	E4	=AND(A4=C4,B4=D4)

Thanks

 

[pmeghnathi]

How do this formula search and match in excl
C1=as D1=cd cell value find in column A & B (A2=as b2=cd)Result true'

 

[pmeghnathi]

@kevin9999
That is a risky formula structure - see row 2 below.

@pmeghnathi
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I would suggest the formulas in the second section below.

23 08 06.xlsm
	A	B	C	D	E
1	as	cd	as	cd	TRUE
2	a	scd	asc	d	TRUE
3
4	as	cd	as	cd	TRUE
5	a	scd	asc	d	FALSE
Compare

Cell Formulas
Range	Formula
E1:E2	E1	=A1&B1=C1&D1
E4:E5	E4	=AND(A4=C4,B4=D4)

How do this formula search and match in excl
C1=as D1=cd cell value find in column A & B (A2=as b2=cd)Result true'
Pl.help

 

[Peter_SSs]

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

@pmeghnathi
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)