Forum Discussion
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...
=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.
Nice! thank you Sergei. Little cleaner and a far outside of my IQ. 🙂