Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Jan 30, 2022
Solved

Compare 2 tables

Hello,   I have a list in 1 sheet and another list in another sheet. I need to tag the ones on sheet 2 that are NOT IN the other list on the other sheet.  The criteria is on Co Name, Invoice Numb...
excel
  • OliverScheurich's avatar
    OliverScheurich
    Jan 30, 2022

    Tony2021 

    =IF(ISNA(VLOOKUP(A2&B2&C2,Paid!$A$2:$A$8&Paid!$B$2:$B$8&Paid!$C$2:$C$8,1,FALSE)),"Not Paid","Paid")

     

    This formula works in my spreadsheet. Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jan 30, 2022

Tony2021 

=IF(ISNA(VLOOKUP(A2&B2&C2,Paid!$A$2:$A$8&Paid!$B$2:$B$8&Paid!$C$2:$C$8,1,FALSE)),"Not Paid","Paid")

 

This formula works in my spreadsheet. Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.

  • Tony2021's avatar
    Tony2021
    Iron Contributor
    Jan 30, 2022

    Hi Quadruple_Pawn, thank you. It worked perfectly! thank you and very grateful for your response.

    FYI (and for other users that read) I work with Office 365 so I did not need ctrl+shift+enter.

     

    Nikolino:

    that would work if the data were the same positions between both tables and although the example I posted was as such, this was only a simple example and not the case in areal world scenario.  thank you for the response though. 

Resources