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

 

[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]

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