Jan 29 2022 06:17 PM
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 Number, and amount which makes it difficult for me.
Please see attached file for a simple example.
thank you very much
Jan 30 2022 01:56 AM
Hier ein einfaches Beispiel wie gewünscht.
Hoffe, dass ich Ihnen mit diesen Informationen und eingefügte Datei weiterhelfen konnte.
War die Antwort nützlich? Markiere sie als hilfreich!
Somit hilfst du allen Forenteilnehmern weiter.
Jan 30 2022 02:00 AM
Solution=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.
Jan 30 2022 03:41 AM - edited Jan 30 2022 03:50 AM
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.
Jan 30 2022 04:54 AM
Jan 30 2022 07:12 AM
Jan 30 2022 02:00 AM
Solution=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.