# Thread: Multiple matches from multiple sheets if criteria is true for multiple sheets Thanks: 0 Likes:  1 Post #5294666 (1)

1. ## Multiple matches from multiple sheets if criteria is true for multiple sheets

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:

 Column A Column B Formula that i need 1 TEXT1 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 2 TEXT1 3 TEXT2

Sheet 2
 Column A Column B 1 TEXT2 1 TEXT1 1 TEXT3

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.

2. ## Re: Multiple matches from multiple sheets if criteria is true for multiple sheets

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

3. ## Re: Multiple matches from multiple sheets if criteria is true for multiple sheets

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

4. ## Re: Multiple matches from multiple sheets if criteria is true for multiple sheets

Im glad to help you and thanks for the feedback.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•