Results 1 to 4 of 4

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

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post 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. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,508
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    12 Thread(s)

    Default 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
    Regards Dante Amor

  3. #3
    New Member
    Join Date
    Jun 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple matches from multiple sheets if criteria is true for multiple sheets

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

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,508
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    12 Thread(s)

    Default Re: Multiple matches from multiple sheets if criteria is true for multiple sheets

    Im glad to help you and thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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