Matching two range of value

[vivian_pinto]

<colgroup><col span="11"><col></colgroup><tbody>
</tbody>

Dear All I am trying to get the result in excel like this.

please help me to get code at MATCHING COLUMN.

RANGE1				RANGE2				MATCHING
NAME	VALUE1	VALUE2		NAME	VALUE1	VALUE2		ANSWER	VALUE1	VALUE2	RESULT
CCC	CC1	CC11		BBB	BB1	BB11		CCC	321	CC11	NOT MATCH
BBB	BB1	BB11		EEE	EE1	EE11		BBB	BB1	BB11	MATCH
DDD	DD1	DD11		CCC	321	CC11		DDD	DD1	555	NOT MATCH
EEE	EE1	EE11		DDD	DD1	555		EEE	EE1	EE11	MATCH

<colgroup><col span="11"><col></colgroup><tbody>
</tbody>

 

[vivian_pinto]

Hi,


Error in A38 and B38 can be ignored.
values are equally sized and look different in size coz its dash separated values.

 

[Aladin Akyurek]

Hi,


Error in A38 and B38 can be ignored.

That means they really exist. That complicates the formula construction.

values are equally sized and look different in size coz its dash separated values.

I meant:

A3:A39 vs B3:B39 vs C3:C43. The latter is bigger (has more rows). How come?

 

[Nishant94]

Excel 2013 32 bit
	A	B	C	D	E	F	G	H	I
1	RANGE1				RANGE2
2	NAME	VALUE1	VALUE2		NAME	VALUE1	VALUE2		Answer
3	CCC	CC1	CC11		BBB	BB1	BB11		Not Match
4	BBB	BB1	BB11		EEE	EE1	EE11		Match
5	DDD	DD1	DD11		CCC	321	CC11		Not Match
6	EEE	EE1	EE11		DDD	DD1	555		Match
7
Sheet2

Cell Formulas
Range	Formula
I3	=IF(VLOOKUP(A3,$E$3:$G$6,2,)&VLOOKUP(A3,$E$3:$G$6,3,0)=B3&C3,"Match","Not Match")

 

[Nishant94]

Another Way:

Excel 2013 32 bit
	A	B	C	D	E	F	G	H	I
1	RANGE1				RANGE2
2	NAME	VALUE1	VALUE2		NAME	VALUE1	VALUE2		Answer
3	CCC	CC1	CC11		BBB	BB1	BB11		Not Match
4	BBB	BB1	BB11		EEE	EE1	EE11		Match
5	DDD	DD1	DD11		CCC	321	CC11		Not Match
6	EEE	EE1	EE11		DDD	DD1	555		Match
7
Sheet2

Cell Formulas
Range	Formula
I3	=IF(SUMPRODUCT(--(INDEX($F$3:$G$6,MATCH(A3,$E$3:$E$6,0),0)=B3:C3))=2,"Match","Not Match")

 

[vivian_pinto]

Hi,

Noting serious in that,

just modify to C3:C39 and delete rest.


thank you

 

[Aladin Akyurek]

Hi,

Noting serious in that,

just modify to C3:C39 and delete rest.


thank you

Would you care also to fill in the expected results in column H of post #8?

 

[vivian_pinto]

Hi,

Thank you for concern,

I just gave those values for example.

I don't need those values to be affected.

Thank you