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.

  • Tony2021's avatar
    Tony2021
    Iron Contributor
    Jan 30, 2022
    Nice! thank you Sergei. Little cleaner and a far outside of my IQ. 🙂

Resources