Multiple matches from multiple sheets if criteria is true for multiple sheets

[rrnXLS]

Hi,
I have two spreadsheets with the same columns names with similar data. i am try to find the difference between each sheet vs the other based on if a certain value is the same on each sheet in a another column.

See below my example sheets for reference to what i am trying to achieve and the "Formula that i need" to solve.

Sheet 1:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Formula that i need[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT1[/TD]
[TD]match TEXT in Column B in both Sheet 1 & 2 only if Column A value (1) is the same as Sheet 2 in Column A value (1) and provide answer of True, otherwise an answer of False[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]TEXT1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]TEXT2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]TEXT3[/TD]
[/TR]
</tbody>[/TABLE]

Any help is much appreciated, i am quite a novice with Excel formulate of this type so just looking for some guidance. By the way i have trying a few things to no avail.

 

[DanteAmor]

Welcome to the forum

Try this array formula

{=IF(SUM(IF(Sheet2!$A$2:$A$4=A2,IF(Sheet2!$B$2:$B$4=B2,1))),TRUE)}

Array formulas
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

 

[rrnXLS]

Wow, that worked like a charm. Thank you so much

 

[DanteAmor]

Im glad to help you and thanks for the feedback.