+ Reply to Thread
Results 1 to 4 of 4

Help with creating a formula to compare data between sheets

  1. 03-04-2024, 11:30 AM #1
    Calvo
    Calvo is offline
    Registered User
    Join Date
    03-04-2024
    Location
    Warsaw
    MS-Off Ver
    Office 365 (MacOS)
    Posts
    2

    Help with creating a formula to compare data between sheets

    I need assistance in creating a formula that allows me to compare data between two sheets. I have a first sheet containing a table with data, specifically the first name and last name in column A and B, the date in cell A1. I would like, on the second sheet, if the first name, last name, and date match the data on the first sheet, to have an "X" appear in the cell corresponding to that person and date. Please see attached file.

    Could someone please help me in creating such a formula? I would greatly appreciate any suggestions and guidance!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-04-2024, 11:59 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,137

    Re: Help with creating a formula to compare data between sheets

    What Excel PRODUCT are you using? O365, excel 2021... or what? Then please update your profile.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 03-05-2024, 04:21 AM #3
    Calvo
    Calvo is offline
    Registered User
    Join Date
    03-04-2024
    Location
    Warsaw
    MS-Off Ver
    Office 365 (MacOS)
    Posts
    2

    Re: Help with creating a formula to compare data between sheets

    Updated. Looking for help.
    Reply With QuoteRegister To Reply
  4. 03-05-2024, 04:27 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,413

    Re: Help with creating a formula to compare data between sheets

    One way:

    =IF(ISNA(XLOOKUP(A2&B2,Arkusz1!$A$3:$A$5&Arkusz1!$B$3:$B$5,Arkusz1!$A$3:$A$5)),"","X")
    Attached Files Attached Files
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to search /compare data from multiple sheets
    By MacDoc in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-11-2021, 08:33 PM
  2. Need formula help to compare 2 data sheets and extract cell value
    By m_roussakis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-05-2020, 08:52 PM
  3. Help with creating a formula [to transfer data from the Main sheet to other sheets]
    By crazinha in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2017, 10:21 AM
  4. formula or macro to compare 2 data sheets and to list up all subject to criteria order sh
    By JEAN1972 in forum Excel General
    Replies: 0
    Last Post: 05-06-2015, 01:10 PM
  5. Help creating Formula(s) to track data between sheets
    By pip74205 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-31-2014, 12:18 AM
  6. Formula to compare two sets of similar data on two sheets
    By twoheadedgames in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-23-2013, 04:18 AM
  7. [SOLVED] Creating a formula to compare 32 sets of data against each other?
    By Trey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2006, 07:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1