Forum Discussion

Jack67's avatar
Jack67
Copper Contributor
Jan 02, 2022

Excel help needed in comparing Data

  Hi All   I need some help with excel formula. Here is my problem statement. Any help/pointers on how to solve this is really helpful   I have 2 documents - Doc1 and Doc2. Below is sample forma...
excel
Jack67's avatar
Jack67
Copper Contributor
Jan 02, 2022
I am facing issues in downloading files. Hence was requesting for details in the chat..
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 02, 2022

Jack67 

In C17 here

enter

=IF(
      ISNA( MATCH($B17, $B$5:$B$7, 0)),
      "Missing in Section 1",
IF( ISNA( MATCH( $B17, $B$11:$B$13, 0)),
      "Missing in Section 2",
IF( INDEX($C$5:$F$7,
          MATCH($B17, $B$5:$B$7, 0),
          MATCH(C$16, $C$4:$F$4, 0) ) =
     INDEX($C$11:$F$13,
           MATCH($B17, $B$11:$B$13, 0),
           MATCH(C$16, $C$4:$F$4, 0) ),
 "Yes", "No") ))

and drag it to the right and down

  • Jack67's avatar
    Jack67
    Copper Contributor
    Jan 02, 2022
    Thank you for sharing your response here. These pointers were very helpful for me.

    Appreciate your time to support me here..

Resources