+ Reply to Thread
Results 1 to 7 of 7

Comparing several cells in 2 tables simultanously

  1. #1
    Registered User
    Join Date
    05-09-2017
    Location
    Austria
    MS-Off Ver
    Excel 2013
    Posts
    4

    Comparing several cells in 2 tables simultanously

    Hello guys,

    I need help in a (for me) complicated problem.
    I have 2 tables (see attachment).
    If the cell I5 ist identical to one cell in the cells B5:B37 AND at the same time cell J5 is identical to one cell in the cells C5:C37 AND the cell in the column F, which is in the same row as the identical cells, then I need a comment (for example X) in cell M5.
    For Example in the attached screenshot I need a X in Cell M15, because the first two cells in table 1 in row 8 are identical to the first 2 cells in table 2 in row 12 AND in cell F8 is a number instead of nothing.

    I would appreciate any help you can give me.

    Yours, Secundus
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    05-09-2017
    Location
    Austria
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Comparing several cells in 2 tables simultanously

    Sorry, wrong Screenshot
    Attached Images Attached Images

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Comparing several cells in 2 tables simultanously

    Welcome to Excel Forum.
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  4. #4
    Registered User
    Join Date
    05-09-2017
    Location
    Austria
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Comparing several cells in 2 tables simultanously

    It would be best if in column M is the content of the corresponding row of table 1 from column F and otherwise the comment "empty"
    For example, because Cells B8 and C8 are identical to cells I11 and J11 in cell M11 is the content of cell F8. If there are no identical cells, then in cell M11 would be written "empty". See Screenshot .

    Thx guys
    Attached Images Attached Images
    Attached Files Attached Files

  5. #5
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Comparing several cells in 2 tables simultanously

    Try

    M5
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and drag down!!!

  6. #6
    Registered User
    Join Date
    05-09-2017
    Location
    Austria
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Comparing several cells in 2 tables simultanously

    It works!!

    Thank you very much

  7. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Comparing several cells in 2 tables simultanously

    An afterthought. In M5 filled down.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Comparing the two tables
    By stribor40 in forum Excel General
    Replies: 4
    Last Post: 12-26-2015, 06:14 AM
  2. Comparing between tables
    By harold12 in forum Excel General
    Replies: 1
    Last Post: 01-23-2014, 06:33 PM
  3. Comparing Two Tables
    By zannnn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-03-2013, 06:58 PM
  4. comparing two tables
    By Tal72 in forum Excel General
    Replies: 1
    Last Post: 03-29-2008, 08:58 AM
  5. Comparing 2 tables
    By blurtoad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2007, 01:33 PM
  6. [SOLVED] Can I use the Goal Seek function on multiple cells simultanously?
    By Nick in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-02-2006, 04:25 AM
  7. Comparing two tables
    By Peter Steiner in forum Excel General
    Replies: 6
    Last Post: 12-23-2005, 06:15 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1